certain time
 

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

certain time
 

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?

--
Biff
Microsoft Excel MVP


"Karl Davidson" wrote in message
...
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

certain time
 

Looking for total hours worked between 2200 to 00600.

"T. Valko" wrote:

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?

--
Biff
Microsoft Excel MVP


"Karl Davidson" wrote in message
...
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

certain time
 

Try this:

A2 = start time
B2 = end time

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

--
Biff
Microsoft Excel MVP


"Karl Davidson" wrote in message
...
Looking for total hours worked between 2200 to 00600.

"T. Valko" wrote:

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?

--
Biff
Microsoft Excel MVP


"Karl Davidson" wrote in message
...
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