Format Code Now
/

Time Sheet Calculator

CU-36

Add up hours worked from start and end times. Put one shift on each line, add an optional break, and get the total as hours and minutes and as decimal hours.

Runs in your browser. Nothing is uploaded.

One shift per line (9:00 AM - 5:30 PM, break 30). Optional line: rate 25.50

Hours

How to use it

  1. Write one shift per line, such as 9:00 AM - 5:30 PM, break 30.
  2. Optionally add a line such as rate 25.50 to get a pay total.
  3. Choose a rounding step if your employer rounds shifts.
  4. Press Add up hours and copy the result.

How shifts and breaks are read

A shift is a start time, a dash or the word to, and an end time. Times can be 24-hour such as 17:45 or 12-hour such as 5:45 PM. A break after the times is taken off as unpaid time, written as minutes (break 30) or hours and minutes (break 0:30). An end time earlier than the start is a shift that runs past midnight. Start and end times that are equal count as zero hours. A label before a bar, such as Mon |, names the line.

Rounding, decimal hours and pay

Each shift is shown as hours and minutes and as decimal hours, so 7:15 is 7.25. If you pick a rounding step, every shift is rounded to the nearest 5, 6, 10, 15 or 30 minutes after its break is removed, halves going up. A rate line multiplies the total minutes by the hourly rate and rounds to the cent. It is a plain calculation: no currency, overtime, tax or labor rules are applied.

Error messages and what to do

MessageWhat it meansFix
Line 1: could not read "9:00". Write a shift like 9:00 AM - 5:30 PM, break 30, or 08:00-16:30.The line has no end time, so it is not a shift.Write a start, a dash and an end, such as 9:00 - 17:00.
Line 1: the break (90 min) is longer than the shift (60 min).The unpaid break is longer than the whole shift.Shorten the break or check the times.

Questions people ask

How do I calculate hours worked?

Subtract the start time from the end time, then subtract unpaid breaks. For 9:00 AM to 5:30 PM with a 30 minute break that is 8 hours. Write the shift as 9:00 AM - 5:30 PM, break 30 and the tool does it for every line.

How do I convert hours and minutes to decimal hours?

Divide the minutes by 60 and add the hours. So 7 hours 15 minutes is 7.25 hours. The tool shows both forms for every shift and for the total, so you can paste whichever your payroll needs.

How are overnight shifts handled?

If the end time is earlier than the start time, the shift is counted as running past midnight. A shift of 22:00 to 6:00 is 8 hours. The result line marks it as crossing midnight so you can spot it.

Can it round to the nearest 15 minutes?

Yes. Choose 5, 6, 10, 15 or 30 minutes under rounding. Each shift is rounded after its break is taken off, to the nearest step with halves going up, and the total is the sum of the rounded shifts.

Does it work out pay?

Yes, if you add a line such as rate 25.50. The total minutes are multiplied by the hourly rate and rounded to the cent. It does not apply overtime, taxes or any labor rule, so check those separately.

About this tool

Each line is one shift: a start time, a dash or the word to, an end time, and an optional unpaid break in minutes (break 30) or hours and minutes (break 0:30). Times can be 24-hour (17:45) or 12-hour with AM or PM (5:45 PM). An end time earlier than the start counts as a shift that crosses midnight; equal times count as zero. Put a label before a | to name a line. A line such as rate 25.50 adds a pay total, computed from total minutes and rounded half up to the cent; it is a plain number with no currency, tax or overtime rules. Rounding applies to each shift after the break comes off. The total is shown as hours and minutes and as decimal hours.

Format Code Now: free, no ads, no accounts. Your input stays in your browser.