How to total a weekly timesheet
Enter each weekday figure and read the total.
1
Fill in each day
Use decimal hours, so 7.5 means 7 hours 30 minutes.
2
Enter zero for days off
A zero keeps the five-day average meaningful.
3
Check the total
The rows show the average, days worked and hours above 40.
What does this tool do?
A five-day timesheet is the sum of the hours recorded each weekday. Enter the daily figures to get the weekly total, the daily average and any hours above a 40-hour week.
The Formula
Weekly total = Mon + Tue + Wed + Thu + FriFrequently Asked Questions
Should I enter paid or clock hours?
Enter the hours that count for the timesheet, usually paid hours after unpaid breaks. Use the break deduction calculator to convert a shift total first.
Why is the daily average divided by five?
The form covers Monday to Friday. Enter zero for a day off so the average still reflects the full working week.