I'm trying to create a spreadsheet that will calculate and track labor costs according to regular and overtime pay. I did some Googling and tried using the MIN and SUM functions which worked partially but not for employees who maybe had days off in the middle of the week and worked longer on the weekend.
I have daily time punches by employee and need to separate it into a regular hrs column and overtime hrs column.
I think it is the standard rules of overtime equaling anything over 8 hours per day and anytime you hit over 40 hours in a week.
I would appreciate any help!
Bookmarks