Hello, need help here:
![73590 73590](https://chandoo.org/forum/data/attachments/73/73682-48f252dbffb5716769bb4a2893dcbef8.jpg)
What formulas to use for K7, L7, M7, and N7?
K7 must reflect the number of hours worked during a regular shift between 6AM and 10PM (L7 for overtime after 8 hours). M7, meanwhile, for number of hours worked during night shift between 10:01PM and 5:59AM the next day (N7 for overtime done falling in that period).
Entire shift can run across regular to night shift, or vice versa.
Entries are entered as date + time. Thank you!
![73590 73590](https://chandoo.org/forum/data/attachments/73/73682-48f252dbffb5716769bb4a2893dcbef8.jpg)
What formulas to use for K7, L7, M7, and N7?
K7 must reflect the number of hours worked during a regular shift between 6AM and 10PM (L7 for overtime after 8 hours). M7, meanwhile, for number of hours worked during night shift between 10:01PM and 5:59AM the next day (N7 for overtime done falling in that period).
Entire shift can run across regular to night shift, or vice versa.
Entries are entered as date + time. Thank you!