Excel question about Time Sheets

  wee eddie 17:21 31 Oct 2008
Locked

I am trying to calculate the hours worked by someone who works through midnight and thereby his Wage for the back-shift. I've tried the Excel Help Files but no luck.

Current set-up:

Date, Start @, Finish @, Hours Worked, Wage.

I can write a fresh Spreadsheet if there is a more suitable format. Currently I'm working it as 2 shifts.

aa.bb.cc to 23.59.00 and 00.01.00 to xx.yy.zz on the following day.

I'm hoping that "Vog" is still around.

  VoG II 18:14 31 Oct 2008

Start time in A1, finish time in B1, duration is given by

=MOD(B1-A1,1)

  VoG II 18:17 31 Oct 2008

Oh and if you want the result in decimal hours

=MOD(B1-A1,1)*24

and format the result cell as Number.

  wee eddie 18:53 31 Oct 2008

Thank you very much

  VoG II 18:59 31 Oct 2008

You are welcome.

By the way, those formulas will work whether a shift crosses midnight or not.

  wee eddie 20:20 31 Oct 2008

with 09.00 to 17.00

  wee eddie 20:20 31 Oct 2008

with 09.00 to 17.00

Thank you very much

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Acer Predator 21X review

14 best picture books for children

Best podcast apps for iPhone & iPad

Les meilleurs ordinateurs portables 2017