Hours and Minutes Calculator
This adds several lengths of time together and gives you one total. It exists because adding times is the arithmetic people most reliably get wrong on a calculator, and the reason is that a calculator works in base ten while time works in base sixty. Type 7.30 plus 8.15 into a phone calculator and it returns 15.45, which looks like an answer and is not one: 7 hours 30 minutes plus 8 hours 15 minutes is 15 hours 45 minutes, and the two only agree by coincidence. Change it to 7 hours 40 minutes plus 8 hours 30 minutes and the calculator says 16.10 while the true answer is 16 hours 10 minutes, which as a decimal is 16.17. Every entry here is kept as hours and minutes, converted to minutes internally, summed, and converted back, so the carry at sixty happens properly. You get the total as hours and minutes, the same total as decimal hours for entering into a payroll system, and the value at an hourly rate. Six rows is enough for a working week with a spare, and any row left at zero is simply ignored.
Adding times on an ordinary calculator fails because minutes carry at sixty, not at a hundred. Rows left at zero are ignored.
How it works
Each entry is converted to minutes by multiplying its hours by 60 and adding its minutes. The minutes are summed, then converted back: the total divided by 60, rounded down, is the hours, and the remainder is the minutes. Decimal hours are the total minutes divided by 60, which is the figure a payroll system wants. The average is the total divided by the number of entries that were not left at zero. Pay is the decimal hours multiplied by the rate.
Worked example
Take the five default entries: 7:30, 8:15, 6:45, 8:00 and 4:30. In minutes those are 450, 495, 405, 480 and 270, which sum to 2,100 minutes. Dividing by 60 gives 35 with no remainder, so the total is 35 hours 0 minutes, or 35.00 decimal hours. At $25 an hour that is $875. Note what an ordinary calculator would have done: 7.30 + 8.15 + 6.45 + 8.00 + 4.30 is 34.20, which is neither the right total nor a meaningful number.
Related calculators
- Hours to Decimal: converting a single entry to decimal.
- Timesheet: start and finish times rather than durations.
- Overtime Pay: hours above the ordinary rate.
- Billable Hours: turning time into an invoice.