Hours Worked Formula Explained, With Examples

Updated 5 Oct 2026 in Date & Time

Every hours worked result comes from one formula. Once you understand what goes into it, you can sanity-check any figure you are given, whether by an employer, a bank, a teacher or another website.

The formula

Hours = out − in − break.

What each input means

Example

For example, with these inputs:

the calculator returns:

How the result changes

The table keeps the other inputs at their example values and changes unpaid break (minutes).

Unpaid break (minutes)Hours workedDecimal hours
08:308 h 15 min8.25 hours
308 h 45 min8.75 hours
458 h 30 min8.50 hours
758 h 00 min8.00 hours
907 h 45 min7.75 hours

Why it matters

Dates and durations matter for notice periods, leave planning, project deadlines and contracts. Counting days on a calendar is slow and easy to get wrong, especially across months of different lengths.

When sharing dates internationally, write the month as a word to avoid confusion between day-month and month-day formats.

The Gregorian calendar has months of 28 to 31 days and adds a leap day almost every four years, which makes counting days by hand surprisingly error-prone. Converting dates to day numbers and subtracting avoids the problem.

Singapore has 11 gazetted public holidays a year, and when one falls on a Sunday the following Monday is a holiday. Working-day calculations therefore need holidays removed separately from weekends.

Related calculations

Use the Hours Worked Calculator to plug in your own numbers.

Run your own numbers: Hours Worked Calculator

Related guides