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!