All spreadsheet templates

Shift hours after unpaid breaks

Convert elapsed shift hours into hours worked after unpaid breaks. Enter elapsed hours as a decimal and breaks in minutes.

Download Excel worksheet

Worked example

Elapsed hoursBreak minutesNet hours
8.5308

Replace the sample values in the blue cells. Each row calculates independently, so you can compare up to 30 entries in one worksheet.

Explore EarnCheck on the App Store

Practice with six flashcards: Timecard and unpaid break arithmetic