Hi,

I am having trouble with a formula to calculate overtime. I have attached an example below. Each employee is scheduled a certain amount of hours (Column D) and when they work past those hours, each additional hour is overtime. I have put in the hours for the start of work and end of work. I also input the dates because sometimes the employees work overnight into a different date. Every six minutes counts as 0.1 hours in our timekeeping. I think I can round up for the hours if they work 15 minutes extra. Thanks for your help.

overtime question.xlsx