Dates & calendar

Time difference and work hours

Work out the time between two clock times and add up the hours of several days; breaks are taken off and night shifts count.

This tool runs entirely inside your browser. No file or text is sent to any server.

How to use

  1. Write the start and the end time, for example 8:30 and 17:15. If you had a break, write its minutes too.
  2. The length of the shift appears beside the boxes at once. For several days, press “Add a row” and write each day in its own row. Pressing Enter moves to the next box, and from the last box it opens a new row.
  3. The total of all rows is shown below, as hours and minutes and as decimal hours. Press “Copy” on either one and paste it into a spreadsheet or a payroll form.

Notes on this tool

If the end time is earlier than the start, the end counts as the next day: from 22:00 to 06:00 is 8 hours. If start and end are the same, the length is zero, not 24 hours.

This tool works on the 24-hour clock and also with AM or PM. That is, next to the numbers 1 to 12 you can write AM or PM. For 12 midnight you can write any of these: 24 or 24:00 or 00:00 or 00 or 0.

If your phone keyboard has no colon, write the time without it, for example 830 or 1715.

The tool adds the minutes exactly and rounds only the last figure, for decimal hours, to two places: 8 hours 20 minutes becomes 8.33.

A row that is incomplete or wrong is left out of the total and the reason is written under it. You can have up to 100 rows.

The tool does not work out overtime, public holidays or leave; it only gives the time between the clock times.

Frequently asked questions

How do I work out the time between two clock times by hand?
Take the start time from the end time. If the end minutes are fewer than the start minutes, turn one hour into 60 minutes and add it to the end minutes. For example from 8:50 to 17:20: write 17:20 as 16 hours 80 minutes and take away 8 hours 50 minutes; the answer is 8 hours 30 minutes.
What are decimal hours used for, and how do I work them out?
Some payroll programs ask for the hours worked as a decimal number. Divide the minutes by 60 and add them to the hours. For example 8 hours 45 minutes is 8 + 45 ÷ 60 = 8.75.
How do I add up work hours in Excel?
Write the times in cells and add them with SUM. Then set the format of the total cell to [h]:mm; otherwise Excel starts again from zero after 24 hours. Get each day’s length as the end minus the start.
Is lunch or a break taken off the work time?
The tool takes off only the minutes you write under “Break”. If your lunch counts as paid work time, leave it out. That depends on your contract and your workplace, not on the tool.

Related tools

Date difference & day counter

How many days lie between two dates, and what date falls a number of days before or after another.

Dates & calendar