Time Calculator Tool
Add up hours and minutes or work hours, even from a pasted list.
The gray values are an example. Type to start your own.
Paste times from Excel or a timesheet
Copy a column of times and paste it here, one per line. Mixed formats such as 1:30, 1h 30m, 90 min and 7.75 are fine.
For two breaks, separate them with a comma, such as 12:00-13:00, 15:00-15:15. 25:00 is read as 1:00 the next day.
| Actual Work | Overtime |
|---|
Rounding, multiply & divide, pay and formats
For example, × 5 for five times, ÷ 3 to split among three people.
For overtime premiums, see the Overtime Pay Calculator; to convert to monthly or yearly pay, the Salary Converter.
How to Use
Choose what to calculate
Use "Add & subtract" to total several times, "Start to end" for the time between two clock times, or "Weekly hours" for a week of shifts.
Enter the times
Type times the way you normally write them, such as 1:30, 1h 30m or 90 min. Paste a whole column from Excel or a timesheet with "Paste a list".
Copy the result
The total appears in hours and minutes, with decimal hours (such as 7.75), minutes, seconds and an Excel-ready [h]:mm value, each with a copy button. Rounding and pay are optional.
What is the Time Calculator?
A calculator for adding and subtracting hours and minutes, the time between a start and end time, and a week of working hours. It reads times however you write them (1:30, 1h 30m, 90 min, 1.5 hours) and lets you paste a whole column copied from Excel or a timesheet. Results are shown in hours and minutes, in decimal hours for payroll, and as [h]:mm so Excel shows totals over 24 hours correctly. Everything is calculated in your browser and nothing is sent anywhere.
Features
- Reads any format1:30, 1h 30m, 90 min, 1.5 hours, 01:30:00 and full-width digits all work as typed.
- Paste and totalPaste a column from Excel or a timesheet and get the total. Rows that cannot be read are marked in red.
- Shifts, breaks and roundingSubtract breaks, handle overnight shifts, round to 15 minutes and more, and calculate pay.
- Decimal hours and [h]:mmGet decimal hours such as 7.75 and Excel-ready values with one-tap copy.
Use Cases
- Totaling hours from a time card or timesheet
- Night and overnight shift hours
- Adding up time spent on tasks, meetings or study
- Adding up video and audio lengths (minutes:seconds)
- Estimating pay from an hourly rate
Related tools
For how many hours are in a month and other conversions, use the Time Period Converter; for days between dates, the Date Calculator; for weeks, the Weeks Calculator; for overtime pay, the Overtime Pay Calculator; and to convert hourly, monthly and yearly pay, the Salary Converter.
FAQ
How do you add hours and minutes?
How do I convert hours and minutes to decimal hours?
Why does Excel show the wrong total when it goes over 24 hours?
Can it handle overnight shifts?
How do I subtract a break?
Can I round to 15 minutes?
Can I add up video or audio lengths to the second?
Can I total a column copied from Excel or a timesheet?
Which formats can I type?
Can it total a week of work hours and overtime?
Updates to this tool
-
Improved
Improved the Time Calculator: paste a column from Excel or a timesheet to total it, type times in any format (1:30, 1h 30m, 90 min), and get work hours with breaks and overnight shifts, rounding to 15 minutes and more, decimal hours and Excel-ready [h]:mm.
Feedback
Missing a feature, or getting a result that looks wrong? Let us know — we improve our tools based on your feedback.