24 hr Time Sheet another ?

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

Chris

Forgot one other thing, for those that do work overnight
they get a 10% diff pay between the hours of midnight and
6am. How to figure this, even for those that work a late
evening, say 13:00-2:00. Did that the other night myself.
Thanks Rag and Peo for the quick response!
 
Does the start time have to be before midnight? If not, how long after
midnight can they start.

Anyway, if they have to start before midnight, the after midnight hours
would me the minimum of 6AM or the endtime

=min(TimeValue(06:00),B2) if endtime is in B2.

=if(endtime<starttime,min(TimeValue(06:00,B2)),0)
 
Back
Top