certain time

[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>

 

[T. Valko]

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?

 

[Karl Davidson]

Looking for total hours worked between 2200 to 00600.

 

[T. Valko]

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