Total a timesheet, plainly.

How the Hour Calculator Works

Each row is one shift. The calculator converts your start and end times to minutes past midnight, finds the difference, adds a day when the shift runs past midnight, then subtracts any unpaid break. The rows are summed into a grand total shown two ways.

The formula

row hours = ( end − start [+ 24h if overnight] − break ) / 60

HH:MM = whole hours : round( fractional hours × 60 )

Reading the two totals

The decimal total (for example 38.75) is what payroll systems usually want. The hours-and-minutes total (38:45) is the same figure written the way a clock shows it.

Tips

• Leave the break blank or zero for shifts with no unpaid break.
• Use am and pm to avoid ambiguity, or switch to 24-hour time.
• Add a row per day to total a full week.