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
 
Back
Top