Hours worked calculator

Timesheet hours from clock-in and clock-out.

This field is for validation purposes and should be left unchanged.
24-hour clock: 9 for 9 am, 14 for 2 pm.
Shift ends
Optional, for the pay figures.
Decimal hours: 7.5 is 7 h 30 min, 8.25 is 8 h 15 min.
For WordPress sites

Put this calculator on your site

Get it as a ready-made Gravity Forms template. Import it, match your colors, publish.

  • Import-ready form file
  • Step-by-step build guide
  • Works with any theme
Get the template · $9 Read the free build guide Requires Gravity Forms (any license).
Advertisement
JetSloth

How it's calculated

Turn each clock time into minutes since midnight, hours times sixty plus minutes. End minus start, less the unpaid break, is the minutes worked; divide by sixty for decimal hours, which is how payroll systems want them. A shift that ends after midnight adds a day, 1,440 minutes, to the end time first. Multiply by shifts per week for weekly hours and by the rate for pay.

Hours = ((End h × 60 + End m) + 1440 × next day − (Start h × 60 + Start m) − Break) ÷ 60
How do I convert minutes to decimal hours for a timesheet?

Divide the minutes by 60: 15 minutes is 0.25, 20 is 0.33, 30 is 0.5, 45 is 0.75. Payroll systems and most employers use decimal hours, so 7 hours 40 minutes is entered as 7.67.

Is my lunch break paid?

In the US, federal law lets employers leave a meal break of 30 minutes or more unpaid if you are fully relieved of duty; short breaks of 5–20 minutes must be paid. States add their own rules. Enter only the unpaid part here.

How do I handle a night shift?

Enter the real clock times and switch "Shift ends" to "Next day": 22:00 to 06:30 with a 30-minute break is 8 hours. Without the switch the end time would be earlier than the start and the result negative.

Advertisement
Gravity Forms

Results are estimates for informational purposes only and are not financial, medical or legal advice.