• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculating regular hours, regular OT, night shift hours, and night shift OT

Status
Not open for further replies.

prragasa

New Member
Hello, need help here:

73593

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!
 
Status
Not open for further replies.
Back
Top