Hello, need help here:
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!
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!