New here and I hope you folks can help. Because I've frazzled my brains trying to figure this one out.



Could someone please provide me with the following formulas?

This is for a daily calculation - no break columns are used.

MONDAY
Col A5 Time Start in Time Format 10:00 PM
Col B5 Time Stop in Time Format 8:00 AM

And here's where I need the formulas:

Col C5 Total Regular Hours in Numerical Value example ( 8.0 )
Col D5 Total Overtime Hours in Numerical Value example ( 2.0 )

Much help needed and many thanks for your considerations!