How to Use the Timesheet Calculator
Choose Weekly for a single Monday–Sunday week, or Biweekly for two weeks back to back. Then type the hours you worked each day. In Hours : Minutes mode you enter hours and minutes separately (for example 8 hours and 30 minutes); in Decimal Hours mode you enter the day as a single decimal such as 8.50. Leave any day you did not work blank. The totals update instantly, and you can press Clear / Reset to start over.
How Timesheet Hours Are Calculated
Each day is converted to minutes, the days are summed, and the total is shown back as hours:minutes and decimal hours. Adding minutes this way means 8h 30m plus 7h 45m becomes 16h 15m — the calculator carries every 60 minutes into an extra hour automatically, so you never have to do the carry by hand.
Weekly Timesheet Example
A standard week with a couple of shorter days:
- Mon — 8h 0m
- Tue — 8h 30m
- Wed — 7h 45m
- Thu — 8h 0m
- Fri — 8h 0m
Adding the minutes: 0 + 30 + 45 + 0 + 0 = 75 minutes, which is 1h 15m. Adding the hours: 8 + 8 + 7 + 8 + 8 = 39h, plus the carried 1h = 40h. So the weekly total is 40h 15m, which is 40.25 decimal hours.
Hours and Minutes vs Decimal Hours
Decimal hours express the minutes part as a fraction of an hour, which is what most payroll systems expect. Divide the minutes by 60 and add the result to the hours:
- 7h 15m = 7 + 15/60 = 7.25
- 7h 30m = 7 + 30/60 = 7.50
- 7h 45m = 7 + 45/60 = 7.75
7h 30m is not 7.30 hours. Writing 7.30 would mean 7 hours and 30 hundredths of an hour — and 0.30 of an hour is only 18 minutes (0.30 × 60). The minutes-to-decimal conversion always divides by 60, never by 100.
Weekly vs Biweekly Timesheets
A weekly timesheet covers one week and produces a single total. A biweekly timesheet covers two consecutive weeks and is common for salaried and semi-monthly payroll. This calculator treats the two weeks separately: you see Week 1 Total, Week 2 Total and a Combined Total, and overtime is judged against the threshold for each week on its own rather than against an 80-hour combined figure.
Calculating Overtime on a Timesheet
Turn on the overtime option and set the weekly threshold — 40 hours by default. Hours up to the threshold count as regular; anything above it counts as overtime. For biweekly timesheets, each week is compared to the threshold independently, so 45 hours in Week 1 and 30 hours in Week 2 gives 5 hours of overtime in Week 1 and none in Week 2 — not 5 hours against a combined 75-hour total. Overtime rules vary by employer and jurisdiction, so treat this as a calculation tool, not legal advice.
Timesheet vs Time Card
A time card records clock-in and clock-out punches and derives the hours from the span between them. A timesheet records the hours worked each day directly, which you then total for the week. If you have punches rather than daily hour totals, use the Time Card Calculator instead.
Common Timesheet Mistakes
- Incorrect decimal conversion — writing 7.30 for 7h 30m. The correct decimal is 7.50, because minutes divide by 60.
- Forgetting breaks — entering 8h when you took an unpaid 30-minute lunch. Enter 7h 30m (or 7.50) so the paid total is right.
- Mixing formats — adding 7.75 to 7h 45m by hand. Pick one format per timesheet, or let the calculator convert.
- Adding weekly totals incorrectly — forgetting to carry minutes into hours. 8h 30m + 7h 45m is 16h 15m, not 15h 75m.
- Applying overtime across two weeks — using an 80-hour biweekly threshold when the rule is 40 hours per week. Calculate each week separately.
FAQs
- How do I calculate my timesheet hours?
- Enter the hours (and minutes) you worked each day. The calculator adds every day together to give your weekly total in hours:minutes and decimal hours. For a biweekly timesheet, switch to biweekly mode and fill in Week 1 and Week 2 — each week is totalled separately and then combined.
- How do I add hours and minutes for a week?
- Add the hours first, then carry extra minutes into hours. For example, 8h 30m + 7h 45m = 15h 75m, and 75 minutes is 1h 15m, so the total is 16h 15m. The calculator does this carry automatically and shows the result in both formats.
- How do I calculate a biweekly timesheet?
- Switch the calculator to biweekly, then enter Week 1 and Week 2 separately. You will see Week 1 Total, Week 2 Total and a Combined Total. Overtime, if enabled, is calculated against the threshold for each week on its own — not against an 80-hour combined total.
- How do I convert timesheet hours to decimals?
- Divide the minutes by 60 and add the result to the hours. 7 hours 30 minutes is 7 + 30/60 = 7.50 decimal hours. You can also switch the calculator to decimal input mode and enter 7.50 directly.
- What is 7 hours 30 minutes in decimal hours?
- 7 hours 30 minutes is 7.50 decimal hours, because 30 minutes is half an hour (30 ÷ 60 = 0.50). It is not 7.30 — 7.30 would mean 7 hours and 30 hundredths of an hour, which is only 18 minutes.
- How do I calculate overtime on a timesheet?
- Turn on the overtime option and set the weekly threshold (40 by default). Hours up to the threshold count as regular; anything above it counts as overtime. For biweekly timesheets each week is compared to the threshold separately. Overtime rules vary by employer and jurisdiction, so treat this as a calculation tool, not legal advice.
- What is the difference between a timesheet and a time card?
- A time card records clock-in and clock-out punches and derives hours from them. A timesheet records the hours worked each day directly, which you then total for the week. Use the Time Card Calculator for punch-based weeks and this Timesheet Calculator when you already know the daily hours.
- Can I leave days blank if I did not work?
- Yes. Leave any day blank and it counts as zero. Days off, weekends and part-time schedules all work — blank days never produce errors or negative totals.