Excel question about Time Sheets

  wee eddie 17:21 31 Oct 08
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 08

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

=MOD(B1-A1,1)

  VoG II 18:17 31 Oct 08

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 08

Thank you very much

  VoG II 18:59 31 Oct 08

You are welcome.

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

  wee eddie 20:20 31 Oct 08

with 09.00 to 17.00

  wee eddie 20:20 31 Oct 08

with 09.00 to 17.00

Thank you very much

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

Sony Xperia XZ Premium review: Hands-on with the new 4K HDR phone with Motion Eye camera and Snapdr5…

1995-2015: How technology has changed the world in 20 years

Best laptop for design and art 2017: we test Apple, Dell, HP, Lenovo and Microsoft's best models…

CarPlay tips & troubleshooting guide: CarPlay tips & troubleshooting guide: Get the most from…