Work, pay & shifts
How to Total a Weekly Timesheet in Decimal Hours
A week of time-clock entries in hours and minutes has to become one decimal number before it can be multiplied by a rate. You can add the minutes first and convert once, or convert each day and add the decimals — and when the days don’t convert exactly, the two routes can end a hundredth or two apart. This guide shows both, explains the gap, and prices the week.
Ready to try the tool this guide describes?
Add first, convert once
Turn each day into minutes, add them, and convert the total. A week of 7:20, 8:20, 6:20, 7:50, and 8:50 is 440 + 500 + 380 + 470 + 530 = 2,320 minutes, or 38 hours 40 minutes. 2,320 ÷ 60 = 38.666…, which is 38.67 to 2 places.
Converting day by day
| Day | Hours and minutes | Exact decimal | Rounded to 2 places |
|---|---|---|---|
| Monday | 7:20 | 7.3333… | 7.33 |
| Tuesday | 8:20 | 8.3333… | 8.33 |
| Wednesday | 6:20 | 6.3333… | 6.33 |
| Thursday | 7:50 | 7.8333… | 7.83 |
| Friday | 8:50 | 8.8333… | 8.83 |
| Week | 38:40 | 38.6666… | 38.65 added, 38.67 converted |
Why the totals differ
Each of those days loses about 0.0033 hours when it is rounded down to 2 places, and five small losses add up to 0.0167 — enough to move the total from 38.67 to 38.65. If some days had rounded up and others down, the errors would partly cancel. Converting the total once has only one rounding step, so it stays within 0.005 hours of the exact time.
Pricing the week
At $25.00 an hour, the exact 2,320 minutes are worth $966.67; 38.67 hours gives $966.75 and 38.65 hours gives $966.25. The differences are small, but they explain why a hand calculation and a payroll figure can disagree by a few cents to a dollar. Which rounding a payroll system uses is its own convention.
A quick checklist
- Total the minutes for the week before converting, or keep at least 4 decimal places per day.
- Divide minutes by 60, never by 100.
- Take breaks off before totaling if your daily entries include them.
- Round once, at the end, to the number of places your timesheet uses.
Weekly Timesheet Totals FAQ
- Should I convert each day to decimal or the weekly total?
- Converting the weekly total once is more accurate; converting each day to 2 places can drift by a hundredth or two.
- Why is my weekly total off by 0.01 or 0.02 hours?
- Each day was rounded to 2 places before adding. Small rounding errors in the same direction add up.
- How do I add up hours and minutes for a week?
- Convert each day to minutes, add them, then divide by 60: 2,320 minutes is 38 hours 40 minutes, or about 38.67 hours.
- How do I work out weekly pay from decimal hours?
- Multiply the decimal total by the hourly rate: 38.67 × $25.00 = $966.75.
- How many decimal places should a weekly total have?
- Whatever your timesheet or payroll system uses — usually 2 — applied once to the total.
Related guides
- Minutes to Decimal ChartEvery minute from 1 to 59 as decimal hours to 2 and 4 places, which minutes convert exactly, and how to read the chart for any time.
- Quarter-Hour RoundingHow rounding times to the nearest 15 minutes works, which minutes round up or down, its decimals, and how it adds up over a week.
Open the tool
Jump into Timesheet Hours to Decimal Converter when you are ready to process your files.
