Add work hours
Add the minutes first, then choose how to view the total.
Label each entry’s format
Enter each duration with an explicit format. Hours-and-minutes uses a colon; decimal hours uses a decimal point. Converting each entry into minutes before adding keeps the sum independent of how its display is formatted.
| Entry | Minutes |
|---|---|
| 08:00 | 480 |
| 07:30 | 450 |
| 08:15 | 495 |
| Total 23:45 | 1425 |
Large totals do not wrap
A duration is allowed to exceed one day. Adding 27:30 and 15:00 gives 42:30, not a clock reading of 18:30. The workbench keeps the whole number of hours visible so a week or project total cannot be mistaken for a time of day.
Split a total at your own threshold
You can choose a threshold and view the part below it separately from the excess. A total of 42:30 with a threshold of 40:00 gives 40:00 regular and 02:30 extra. That threshold is your input. It does not establish a legal overtime boundary or an amount owed.
Do not round each display before adding
Three 20-minute entries total 60 minutes. Adding three two-decimal displays of 0.33 instead gives 0.99 hours and loses the original exact total. Preserve the minute values, especially when combining rows from a time card or spreadsheet.
Frequently asked questions
Can the list mix HH:MM and decimal entries?
Yes. Choose the format for each entry explicitly. The example 07:30 plus 7.30 decimal hours adds 450 and 438 minutes, giving 14:48.
Will a long total wrap back to zero after twenty-four hours?
No. A duration total keeps its full hour count. Twenty-seven hours and thirty minutes is displayed as 27:30.
Sources and method
- NIST SP 330, Section 4, Table 8Time-unit definitions only; not a payroll authority or product endorsement.