How to Convert Weekly Hours for Payroll

Step 1: Use each day’s paid hours

Start with the paid time for each day. The daily figure should already have any unpaid breaks removed.

For example:

• Time at work: 08:30–17:00 = 8h30m
• Unpaid break: 30m
• Paid time: 8h00m

The figure to use in the weekly total is therefore 8h00m.

Do not subtract the break again later when adding the week.

For more detail, see How Breaks Affect Payroll Hours.

Step 2: Add the hours and minutes separately

When working manually, it is often easiest to add the whole hours and minutes separately.

For example:

• Monday: 7h35m
• Tuesday: 8h20m
• Wednesday: 7h50m
• Thursday: 8h10m
• Friday: 6h45m

Add the whole hours:

7 + 8 + 7 + 8 + 6 = 36 hours

Then add the minutes:

35 + 20 + 50 + 10 + 45 = 160 minutes

At this stage, the weekly total is 36 hours + 160 minutes. The next step is to convert those excess minutes into hours.

Step 3: Carry minutes over 60

There are 60 minutes in 1 hour, so:

160 minutes = 2 hours 40 minutes

Add those 2 hours to the original 36 hours:

36h + 2h40m = 38h40m

The exact weekly paid time is therefore 38h40m.

This is the important step that is easy to miss when adding weekly timesheets manually.

Step 4: Convert the final minutes to decimal hours

If payroll expects decimal hours, convert the remaining minutes by dividing them by 60.

For 40 minutes:

40 ÷ 60 = 0.6666…

So 38h40m ≈ 38.67 hours. The weekly payroll figure is 38.67 when rounded to two decimal places.

Full weekly payroll example

The calculation is:

• Whole hours: 7 + 8 + 7 + 8 + 6 = 36
• Minutes: 35 + 20 + 50 + 10 + 45 = 160
• 160 minutes = 2h40m
• 36h + 2h40m = 38h40m
• 40 ÷ 60 = 0.6666…

So: 38h40m ≈ 38.67 decimal hours

Should you convert each day first or convert the weekly total?

There are two ways to calculate weekly payroll hours.

Method 1: Add exact hours and minutes first

With this method, you keep every daily value in hours and minutes. You then:

1. add the whole week
2. carry excess minutes into hours
3. convert the final minute remainder to decimal hours

This is usually the cleanest manual method. It also helps reduce cumulative rounding differences.

Method 2: Convert each day into decimal hours first

You can also convert each day into decimal hours and then add the decimal values together.

This works well if the exact decimal values are retained.

The problem appears when each daily value is rounded too early. For example, 7h05m:

5 ÷ 60 = 0.083333…

So the exact decimal is 7.083333…

If this is rounded immediately to 7.08, and the same thing happens across several days, the final weekly total can differ slightly from the result produced using the original exact time.

A useful rule is: keep the source time exact and round only at the end, unless your payroll system specifically requires daily rounding.

Example with awkward weekly minutes

Not every weekly total ends in 15, 30 or 45 minutes.

For example, a weekly paid time of 39h42m. Convert the 42 minutes:

42 ÷ 60 = 0.70

So: 39h42m = 39.70 decimal hours

This is a good example of why minutes cannot simply be copied after the decimal point. 39h42m is not 39.42 hours.

What figure should go into payroll?

That depends on the format your payroll system expects.

• If it uses hours and minutes: 39h42m
• If it uses decimal hours: 39.70

Do not enter 39.42, because 0.42 hours = 25.2 minutes, not 42 minutes.

For a fuller explanation, see Timesheet Hours and Minutes vs Decimal Hours.

What about a part-time or partial week?

The calculation is exactly the same.

• Monday: 6h30m
• Wednesday: 7h15m
• Friday: 5h45m

Add the hours:

6 + 7 + 5 = 18

Add the minutes:

30 + 15 + 45 = 90 minutes = 1h30m

So:

18h + 1h30m = 19h30m

Convert 30 minutes (30 ÷ 60 = 0.50): weekly payroll total 19.50 hours

The same method works for:

• part-time workers
• midweek starters
• short working weeks
• weeks containing sickness or leave
• irregular working patterns

What if one day contains two shifts?

If someone works two separate periods on the same day, calculate the daily total first.

• Morning: 08:00–12:00 = 4h
• Afternoon: 14:00–17:30 = 3h30m
• Daily paid time: 7h30m

That daily figure is then added to the rest of the week. If the payroll system uses decimals, 7h30m = 7.50 hours.

What if one day is an overnight shift?

Once the paid duration of the overnight shift has been calculated, it can be added to the weekly total just like any other day.

For example, a paid overnight duration of 7h30m is 7.50 hours.

You do not need a different weekly calculation method just because one shift crossed midnight.

For the detailed calculation, see How to Calculate a Night Shift Across Midnight.

Weekly hours and overtime

Calculate the accurate weekly paid-hours total before working out overtime.

For example, with weekly paid hours of 42.75, that total can then be compared with the relevant contractual or payroll threshold.

There is no single overtime threshold that applies to every job or employer.

For the next step, see How to Calculate Overtime in Decimal Hours.

Exact conversion vs payroll rounding

Converting time and rounding time are not the same thing.

For example, for 38h50m:

50 ÷ 60 = 0.8333…

So 38h50m ≈ 38.83 hours. That is simply the decimal conversion rounded to two decimal places.

An employer or payroll system may also have its own rules about how clock times or daily records are rounded. Those rules are separate from the mathematical conversion.

If no rounding rule applies, keep the original time exact for as long as possible.

How to check a weekly payroll total

Before entering a weekly total into payroll, check the calculation in this order:

1. confirm each day’s paid hours
2. make sure unpaid breaks have already been removed
3. add all whole hours
4. add all minutes separately
5. convert every 60 minutes into 1 hour
6. add those extra hours to the total
7. convert the final remaining minutes to decimal hours
8. round only if required
9. enter the final weekly figure into payroll

This makes it easier to spot where an error has occurred.

Common mistakes when converting weekly hours

Entering clock minutes as decimal minutes

38h40m is not 38.40 hours. The correct decimal value is approximately 38.67.

Forgetting to carry minutes over 60

If the weekly minute total is 140 minutes, that must be converted to 2h20m before the final decimal conversion.

Rounding every day too early

Repeated daily rounding can introduce small differences across the week.

Double-subtracting unpaid breaks

If the daily figure already represents paid time, do not remove the break again from the weekly total.

Mixing hours and minutes with decimal hours

Convert everything into the same format before adding values together.

Using scheduled hours instead of paid hours

If actual paid-time records are available, do not automatically substitute the rota hours.

Calculating overtime before the weekly total is correct

Get the exact weekly paid-hours figure first.