Timesheet calculation problems

[DrGnBld]

Hi All,
Ive got a timesheet shell for my company and ive got most of the coding exactly where i want it and was happy with it, right up until i began working nights. The math doesnt work out properly when i do an overnight shift, and i cant figure out how to get it right for the life of me. Sadly, due to the nature of my job, i dont always work the same shifts, so if anyone can be of help, that would be great. I am also more than happy to provide any answers to questions you may have regarding how the sheet works.

[ELeGault]

When you are doing overnight times you need to simply take ("24:00:00" - LogIn) + Logout
Start by testing your start/End times - if the END time is LESS than the START time than you know you need to invert your data and find the difference between the End of the day and the start time and add the End time to that difference.

Lets modify your rows 12/13 where I12 = Login and I13 = Logout

Please Login or Register  to view this content.

Next you will want to check your break times for the same setup
Lets do this again where L13 = Break Start and L14 = Break End

Please Login or Register  to view this content.

Now lets throw them together with your original Error Check
Cell M4 should read the following...

Please Login or Register  to view this content.

Also note that if you do not have a start time it is blank which is why I used the ISBLANK formula instead of repeating an entire evaluation to find out if it is 0.

Take a stab at modifying the other formulas with this in mind.
Let me know if you are still stumped.

Cheers -

[DrGnBld]

You sir are a LIFESAVER. Thank you so very much

[ELeGault]

Always a pleasure - Please be sure to mark this as solved if it is complete - and Cheers!