How do I sum time in excel and have it separate into standard hours worked and overtime hours worked for the day. Then possibly for the week.
-Day Example:
6AM to 6PM =12 hours total = 8 standard hours and 4 overtime hours
-Week Example: (if worked same time as above for 5 days)
40 hrs standard
20 hrs overtime
Bookmarks