Good afternoon All -
This is my first time on this forum and I love the amount of information I have already learned.
My question is:

I have two colums - shift start and shift end.
Shift Start Shift End
0:00 05:00

I need to calculate the hours between 00:00-04:00 and the amount of hours bewteen 04:00-06:00.
For 00:00-0400 this example would show 4 hours
For 04:00-06:00 this example would show 1 hour

Please help as I am trying to calculate time shift premiums.

Thank you.
Jenny