Excel question about Time Sheets

  wee eddie 17:21 31 Oct 2008

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


  VoG II 18:17 31 Oct 2008

Oh and if you want the result in decimal hours


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

iMac Pro review

See iconic duo Smith and Foulkes' epic animation for the BBC's Winter Olympics coverage

iMac Pro review

Idées cadeaux pour geeks et tech addicts