calculation

  • Thread starter Thread starter Chris Watson
  • Start date Start date
C

Chris Watson

I have a cell with a start time and a cell with a finish time,
the start time is: ie 05:00 and the finish time is: ie 20:00.
I have the formula for total time worked but im wanting a formula that
will calculate the hours worked before 06:00 and after 18:00
as these are overtime hours and need to be calculated seperately.

Can anybody help please

Chris
 
Start time in A2, end time in B2

OT would be

=MAX("06:00"-A2,0)+MAX(B2-"18:00",0)

now that means the start at 05:00 but end at 12:00 would still get OT,
 
Back
Top