How to Calculate Hours Worked (Time Card Calculator Guide)
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
- Convert both times to the 24-hour clock (5:15 p.m. → 17:15).
- Subtract the start time from the end time.
- Subtract unpaid breaks.
- 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
- First, convert: 8:45 a.m. stays 08:45; 5:15 p.m. becomes 17:15.
- Next, subtract: 17:15 − 08:45. Borrow an hour: 16:75 − 08:45 = 8 h 30 min.
- Then take off a 30-minute unpaid lunch: 8 h 00 min.
- 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.
