Time & Hours Calculator

about this tool

Add up hours and minutes

Time does not add like ordinary numbers: 2:45 plus 1:50 is 4:35, not 3:95. Type one time per line, in whatever shape you have it — 2:45, 1h 50m, 90 min, or 1.5 for an hour and a half — and the total appears as you type. Press the sign beside a line to take it away instead of adding it.

Every total is shown three ways: as hours and minutes (4:35), as decimal hours (4.58, what timesheets and invoices ask for), and in words. A total past a day is also shown in days, so 28:30 reads as 1 day 4 hours 30 minutes.

What time will it be

Give a time of day and a duration, choose after or before, and the page says what the clock will read and on which day: 7 hours 45 minutes after 9:30 PM is 5:15 AM the next day. How long between does the reverse — from 10:00 PM to 6:30 AM is 8 hours 30 minutes, overnight. Switch the answers between 12-hour and 24-hour clocks at the top; the time fields themselves follow your device's setting.

A timesheet with breaks, overtime and pay

Give each day a start, a finish and an unpaid break in minutes (or written out, such as 1h or 0:45). Each day's hours appear beside it, and below them the week's total in hours and minutes and as a decimal. A finish earlier than the start is a night shift ending the next morning.

Overtime can be counted per week — every hour past 40, say — or per day, past 8 hours on each day separately. For a sheet longer than a week, each run of seven rows counts as a week of its own. Add a pay rate and the page splits the pay into regular and overtime at the multiple you give, rounded to the cent once for each part, so the parts add up to the total shown. Overtime law differs between countries, states and contracts; this does the arithmetic, not the law.

Copy table puts the whole sheet on the clipboard as tab-separated lines, ready to paste into a spreadsheet, with its times in the clock style chosen at the top. Each decimal is rounded to two places on its own, so a column of them can differ from the total by a few hundredths: the total is worked out from the exact minutes.

Related

To convert one way of writing a duration into another — PT2H30M, 2h30m, seconds — use the duration converter. For days, weeks and months between two dates, use the date difference calculator.

questions

How do I add hours and minutes together?

Type one time per line — 2:45, 1h 50m, 90 min, or 1.5 for an hour and a half — and the total appears as you type, in hours and minutes, in decimal hours and in words. Press the + next to a line to make it a − and take it away instead.

How do I convert hours and minutes to decimal hours?

Divide the minutes by 60 and add them to the hours: 7 hours 30 minutes is 7.50, 7:15 is 7.25, and 7:20 is 7.33. Every total here is shown both ways, to two decimal places, which is what a payroll form or an invoice usually asks for.

How do I work out hours worked across midnight?

Give the finish time as it reads on the clock — 6:00 for six in the morning — and a finish earlier than the start is taken as the next day. 10:00 PM to 6:30 AM is 8 hours 30 minutes, and the shift is marked overnight.

How is overtime worked out?

Choose per week to count every hour past a weekly total (40 by default) as overtime — each run of seven rows being a week — or per day to count the hours past a daily limit (8 by default) on each day separately. Overtime is paid at the rate times the multiple you give, 1.5 by default. Rules differ by country, state and contract, so check yours.

Is a break in minutes or hours?

A bare number in the break column is minutes, so 30 is half an hour. You can also write 1h, 45m or 0:45. The break is taken off the time between start and finish.

Can I paste the timesheet into a spreadsheet?

Yes. Copy table gives a tab-separated table — day, start, finish, break, hours and decimal hours, then the total and the overtime — that pastes straight into Excel, Google Sheets or Numbers.