How to Calculate Hours Worked (Time Card Calculator Guide)

How to Calculate Hours Worked: Time cards and decimal hours
Spread the love

An hours calculator or time card calculator turns clock-in and clock-out times into hours worked, ready for a timesheet or payroll. You can do the same by hand in a few steps.

Quick answer

  1. Convert both times to the 24-hour clock (5:15 p.m. → 17:15).
  2. Subtract the start time from the end time.
  3. Subtract unpaid breaks.
  4. Convert minutes to decimal hours by dividing by 60.

Example: 8:45 a.m. to 5:15 p.m. is 8 h 30 min, or 8.5 hours, before breaks.

Step-by-step example

  1. First, convert: 8:45 a.m. stays 08:45; 5:15 p.m. becomes 17:15.
  2. Next, subtract: 17:15 − 08:45. Borrow an hour: 16:75 − 08:45 = 8 h 30 min.
  3. Then take off a 30-minute unpaid lunch: 8 h 00 min.
  4. Finally, in decimal hours: 8.00.

For the 24-hour clock, see the military time chart.

Minutes to decimal hours

Minutes Decimal hours
5 0.08
6 0.10
10 0.17
12 0.20
15 0.25
20 0.33
30 0.50
40 0.67
45 0.75
50 0.83

Payroll uses decimal hours. 7 h 45 min is 7.75 hours, not 7.45.

Weekly time card example

Day In Out Unpaid break Hours worked Decimal
Mon 8:45 a.m. 5:15 p.m. 30 min 8 h 00 min 8.00
Tue 9:00 a.m. 5:30 p.m. 30 min 8 h 00 min 8.00
Wed 8:30 a.m. 4:45 p.m. 45 min 7 h 30 min 7.50
Thu 9:00 a.m. 6:00 p.m. 60 min 8 h 00 min 8.00
Fri 8:00 a.m. 12:15 p.m. 0 min 4 h 15 min 4.25

Weekly total: 35 h 45 min, or 35.75 hours. At $22 an hour, that’s $786.50 before tax.

Overnight shifts

If a shift crosses midnight, add 24 hours to the end time before subtracting. A shift from 10:00 p.m. to 6:30 a.m.: (6:30 + 24:00) − 22:00 = 8 h 30 min.

Overtime

In the US, many hourly employees must be paid 1.5 times their regular rate for hours over 40 in a workweek, though rules depend on the job and state. Keep accurate daily records so overtime is easy to check. To turn hourly pay into a yearly figure, see hourly to salary.

In a spreadsheet

Put the start time in A2 and the end time in B2, both formatted as times. =(B2-A2)*24 gives decimal hours. For overnight shifts, use =MOD(B2-A2,1)*24.

Frequently asked questions

How do I calculate hours worked?

Subtract the start time from the end time, take off unpaid breaks, and convert minutes to decimal hours.

How many hours is 8:30 to 5:00?

8.5 hours before breaks.

What is 45 minutes in decimal hours?

0.75 hours.

How do I calculate an overnight shift?

Add 24 hours to the end time before subtracting the start time.

Related guides

Related guides

Leave a Reply

Your email address will not be published. Required fields are marked *