Shift Differential Formula

[LVSU]

I am looking for a formula to tabulate a formula for shift differential
between the hours of 17:00 and 7:00. If you had worked this shift you would
have 14 hours of shift differential.
If you worked 9:00 - 19:00 you would have 2 hours of shift differential.
Column D7 is the start time and E7 is the end time, with the shift diff
tabulating in K7.
Thanks.

 

[jlclyde]

I am looking for a formula to tabulate a formula for shift differential
between the hours of 17:00 and 7:00. If you had worked this shift you would
have 14 hours of shift differential.
If you worked 9:00 - 19:00 you would have 2 hours of shift differential.
Column D7 is the start time and E7 is the end time, with the shift diff
tabulating in K7.
Thanks.

for instance the start time woudl be in Column A. If you type in the
times into a cell and format the cell as numbers, this will tell you
how Excel views these times. Then just a simple If statement with an
Or in there and there you go. So this eads that if the start time is
greater then .71 or less then or = to 1 then it will activate or if it
is between .29 and .001, then it will activate, if not then it will be
0.

=IF(OR(OR(A13>=0.71,A13<=1),OR(A13>=0.01,A13<=0.29)),1,0)

Jay