Step 1. Convert each time to minutes
Minutes from midnight = (hours × 60) + minutes. For 12-hour times, convert to 24-hour time first: 1:00 PM is 13:00, so 13 × 60 = 780 minutes. 9:00 AM is 540 minutes. 5:30 PM is 17:30, or 1,050 minutes.
Step 2. Subtract to get the shift length
Gross minutes = clock-out minutes − clock-in minutes. If the answer is negative or zero, the shift crossed midnight; add 1,440 minutes (24 hours). See overnight shift hours for a full explanation.
Step 3. Subtract unpaid breaks
Net minutes = gross minutes − unpaid break minutes. If you had two unpaid breaks, add them first. Do not subtract paid rest time unless your workplace tells you to.
Step 4. Convert back
Hours = whole number of 60-minute blocks left in the net total. Remaining minutes stay as minutes. Decimal hours = net minutes ÷ 60. For a two-decimal timesheet figure, round to the nearest hundredth.
Worked example
Clock in 08:45 (525 minutes), clock out 17:15 (1,035 minutes), unpaid lunch 45 minutes.
Gross = 1,035 − 525 = 510 minutes (8 hours 30 minutes). Net = 510 − 45 = 465 minutes. That is 7 hours 45 minutes, or 7.75 decimal hours.
Adding a week
Repeat the same calculation for each day, then add the net minutes. Divide the weekly total by 60 for decimal hours. The weekly timesheet does this as you type.
This is time arithmetic, not a guide to pay, overtime thresholds, or legal working-time limits.