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

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?