Add hours: total a week of work time
Enter how long was worked each day. You get the weekly total in hours and minutes and as a decimal for the timesheet.
Calculator
Enter the time worked for each day, as hours and minutes (7:45) or as a decimal (7.75). Under each field you can see how it was read, so 7.45 never quietly means something other than what you intended.
Empty does not count
Empty does not count
Empty does not count
Empty does not count
Empty does not count
Empty does not count
Empty does not count
Enter at least one day to see the total.
What this calculator does not do: it deducts no break (enter the time worked, not the time on site), it does not know what your contract calls a full week, and it says nothing about overtime or premiums.
How do you add up work hours correctly?
Adding hours takes two steps: add the hours and the minutes separately, then turn every sixty minutes into an hour. Monday 7:45 and Tuesday 8:30 make 15 hours and 75 minutes, which is 16:15. Add them as ordinary decimals and you get 15.75, half an hour off. The calculator therefore counts in minutes internally and only converts the total at the end.
- Minutes count to sixty, not to a hundred
- 7:45 plus 8:30 is 16:15, not 15.75
- The total is shown in both forms so you can check it
Colon or point: 7:45 is not 7.45
This calculator reads 7:45, with a colon, as seven hours and forty-five minutes. A number with a point is a decimal: 7.75 is also seven hours and forty-five minutes, while 7.45 is only seven hours and 27 minutes. Mixing the two up is easy when a timesheet shows clock times, so this is the one place to be careful. On one day it is an 18-minute difference, over a five-day week about an hour and a half. That is why the line under each field says how your entry was read.
- 7:45 is seven hours and 45 minutes
- 7.75 is the same as a decimal; 7.45 is 7 hours and 27 minutes
- A whole number such as 8 counts as a number of hours
Adding hours in Excel: why the total resets at 24 hours
When you type 7:45 into a cell, Excel turns it into a time of day, and that only runs from 0:00 to 23:59. Add up a week and a cell formatted as h:mm shows only what is left over after whole days: 38 hours appear as 14:00. The total is right, only the display is not. With the custom format [h]:mm, with the square brackets, the cell shows 38:00. For a decimal, multiply the total by 24 and format the cell as a number.
- h:mm resets at 24 hours, [h]:mm does not
- Total times 24 gives the hours as a decimal
- The calculator points this out when your total passes that limit
Adding up a week is not the same as keeping a month
The calculator adds seven fields and remembers nothing. For a single check that is enough. For a whole month with start times, end times and breaks, time tracking that does this sum for every day by itself is worth having.
- For one week: this calculator
- For a month: a spreadsheet or an app
- For a team that clocks in on its own: an app rather than a file
If you do not have the hours per day yet
If the slip only shows a start and an end, first work out how long each shift lasted: the hours calculator does that, with break and night shifts. If you have a number of minutes, minutes to hours converts it to the decimal that fits in each field here. For a whole team, see timesheets.
See Celtucom with your own team
Book a walkthrough and we'll show you how it fits the way your organization actually works.