Timesheet Hours and Minutes vs Decimal Hours

What are hours and minutes?

Hours and minutes use normal clock time. One hour contains 60 minutes.

So:

• 7:15 = 7 hours 15 minutes
• 7:30 = 7 hours 30 minutes
• 7:45 = 7 hours 45 minutes

This is the format most people naturally use when reading:

• clocks
• rotas
• shift times
• start and finish times
• break lengths

For example, if your shift lasted 8 hours 30 minutes, you might write it as 8h 30m or 8:30. Both describe normal hours and minutes.

What are decimal hours?

Decimal hours express part of an hour as a fraction of 1.00.

Instead of dividing an hour into 60 minutes, the fraction of the hour is written as a decimal.

For example:

15 ÷ 60 = 0.25

So 15 minutes = 0.25 hours. Likewise, 30 minutes = 0.50 hours and 45 minutes = 0.75 hours.

So:

• 7h 15m = 7.25 hours
• 7h 30m = 7.50 hours
• 7h 45m = 7.75 hours

Decimal hours are commonly used where time needs to be added, multiplied or processed mathematically.

Why 7:30 and 7.30 are different

This is one of the easiest timesheet mistakes to make.

7:30

The colon indicates normal hours and minutes, so 7:30 = 7 hours 30 minutes.

7.30

If this is a decimal-hours value, it means 7 hours + 0.30 of an hour.

To convert the decimal part back into minutes:

0.30 × 60 = 18

So: 7.30 decimal hours = 7 hours 18 minutes

The correct decimal version of 7 hours 30 minutes is 7.50, because 30 ÷ 60 = 0.50.

Therefore: 7h 30m = 7.50 decimal hours, not 7.30.

Why the two formats are easy to confuse

The problem is that the numbers look very similar. For example, 8:45 and 8.45 may look almost identical. But they represent different amounts of time.

8:45

Means 8 hours 45 minutes. Decimal equivalent: 8.75 hours.

8.45 decimal hours

Means 8 hours + 0.45 of an hour.

0.45 × 60 = 27 minutes

So: 8.45 decimal hours = 8 hours 27 minutes. That is an 18-minute difference.

The punctuation matters:

• a colon usually means hours and minutes
• a decimal point usually means a fraction of an hour

The same worked time in both formats

Here are some common timesheet values shown both ways:

The amount of time is the same. Only the format changes.

For a larger lookup table, see the Decimal Hours Conversion Chart.

How to tell which format your timesheet uses

Sometimes the format is obvious.

Likely hours and minutes

Values such as 7:30, 8:15 and 9:45 usually represent normal hours and minutes.

Likely decimal hours

Values such as 7.50, 8.25 and 9.75 usually represent decimal hours.

But values such as 7.30 can cause confusion.

If your timesheet uses a decimal point, check whether the system expects decimal hours rather than clock-style minutes.

If you enter 7.30 when you actually worked 7h 30m, you could understate the time by 12 minutes, because 7.30 = 7h 18m whereas 7h 30m = 7.50.

Why timesheets use hours and minutes

Hours and minutes are easier for people to read. A rota showing 07:30–15:30 is immediately understandable.

The same applies to:

• shift times
• lunch breaks
• appointments
• working patterns
• clock-in and clock-out records

People naturally think in 60-minute hours. That is why hours and minutes are often used when recording the original time.

Why payroll often uses decimal hours

Decimal hours are easier to calculate with.

For example, 7h 30m becomes 7.50 hours. If the hourly rate is £15:

7.50 × £15 = £112.50

That is much easier than trying to multiply an hourly rate directly by 7 hours 30 minutes.

Decimal hours are also useful for:

• payroll systems
• spreadsheets
• invoicing
• overtime calculations
• weekly totals
• billable time

For a fuller explanation, see Decimal Hours for Payroll Explained.

How to read decimal hours back into hours and minutes

To convert decimal hours back into normal time:

Decimal part × 60 = minutes

• 8.25 hours: 0.25 × 60 = 15 minutes, so 8.25 = 8h 15m
• 8.50 hours: 0.50 × 60 = 30 minutes, so 8.50 = 8h 30m
• 8.75 hours: 0.75 × 60 = 45 minutes, so 8.75 = 8h 45m
• 8.30 hours: 0.30 × 60 = 18 minutes, so 8.30 = 8h 18m

This is why it is important not to read the digits after the decimal point as ordinary clock minutes.

For more examples, see Decimal Hours to Hours and Minutes, or try the Time Converter.

Do not mix hours and minutes with decimal hours

Values in the two formats should not be added together until they have been converted into the same format.

For example, 7:30 + 8.25 is a mixture of hours and minutes and decimal hours.

Convert 7h 30m first:

7h 30m = 7.50

Then:

7.50 + 8.25 = 15.75 hours

And 15.75 hours = 15h 45m.

Keeping everything in one format avoids calculation errors.

Conversion is not the same as rounding

Converting hours and minutes to decimal hours is a mathematical conversion.

For example:

50 ÷ 60 = 0.8333…

So 7h 50m ≈ 7.83 decimal hours. The decimal has been rounded to two decimal places for display.

Payroll rounding is different. An employer or payroll system may have separate rules about how clock times or worked hours are rounded.

Do not assume a payroll rounding rule simply because a decimal result needs to be displayed to two decimal places.

For the full step-by-step conversion process, see How to Convert a Timesheet to Decimal Hours.

Quick comparison: hours and minutes vs decimal hours

Hours and minutes

• based on 60 minutes per hour
• easier for people to read
• commonly used for clocks and rotas
• often written with a colon or h and m

Example: 7h 30m

Decimal hours

• represents an hour as 1.00
• easier for mathematical calculations
• commonly used for payroll and spreadsheets
• written with a decimal point

Example: 7.50

Both can represent exactly the same amount of time. The important thing is knowing which format you are looking at.

Common mistakes with timesheet formats

Assuming 7.30 means 7h 30m

It does not if the value is decimal hours. 7.30 hours = 7h 18m.

Typing clock minutes after the decimal point

If you worked 8h 45m, the decimal entry is 8.75, not 8.45.

Reading 8.50 as 8h 50m

8.50 hours = 8h 30m

Mixing formats in the same calculation

Convert all values into the same format before adding or subtracting them.

Confusing conversion with rounding

Changing hours and minutes into decimal hours is separate from any payroll rounding policy.

Assuming every timesheet uses the same format

Some systems use clock-style time. Others use decimal hours. Check the labels or instructions if you are unsure.