24 hr Time Sheet another ?

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!
 
T

Tom Ogilvy

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if night shift by start & end time 2
time diffrence with 24 hour clock 3
certain time 3
IF calculation of Time 2
Calculating Times for Pay Rates 4
How can I work out how many hours I get premium rate? 4
Tinme calculations once more 11
Calculate time worked based on start / end times & working hours 3

Top