certain time

  • Thread starter Thread starter Karl Davidson
  • Start date Start date
K

Karl Davidson

I have to compute an extra night pay rate for those who work between 22:00
to 06:00 the following day. Can this information be taken from the Start
Time and Ending Time? And is the a formula that will look between these hours
only>
 
What result are you looking for? The number of hours worked during that
shift? Or, just some kind of confirmation that they worked at some time
during that shift?
 
Try this:

A2 = start time
B2 = end time

=(MOD(B2-A2,1)-(A2>B2)*MEDIAN(0,B2-6/24,16/24)-MAX(0,MIN(11/12,B2+(A2>B2))-MAX(6/24,A2)))*24
 

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

Calculate elapsed time excluding specific timeframe 10
Determine if night shift by start & end time 2
I need Time Range to return Value 4
Pay rate Calculation for different shifts 2
Total time vs hours per shift 1
Complex If then? 4
Calculating time for 3rd shift 4
Still problems with calculation of time 5

Back
Top