Using Excel to Calculate Hours Worked
December 5, 2008 8:10 AM Subscribe
Excel Filter: Working on a timesheet and trying to calculate regular and overtime pay on a daily basis...kind of
posted by kasperj74 to computers & internet (12 answers total) 1 user marked this as a favorite
Ok, I am working on a timesheet for my employees. We calculate overtime based on whether they work over 40 hours in a week, not 8 hours in a day. I am trying to figure out an excel formula to watch the total number of hours worked in a week and if it goes over 40 to put the hours up to 40 into the regular hours column and the remainder into the overtime column. And any hours worked in subsequent days put into the overtime column because...well...that is overtime. See an example of my spreadsheet here
The S column is calculating the hours worked based on the arrive and depart columns. T converts that to a number and U is a running total of hours worked in the week. Column N is hours worked minus Lunch/Break. If you see any easier way to simplify this it would be greatly appreciated.