Timesheet in decimal hours and hours and minutes

Each day shows twice, as hours and minutes (7:50) and as decimal hours (7.83), then rounded to a step you choose. A table converts minutes to decimals by hand.

  • No email needed
  • Last reviewed 15 November 2026

For Google Sheets, download the .xlsx and open it with File > Import.

What it's for

  • Turning hours and minutes into the decimal hours payroll or invoicing asks for.
  • Seeing the effect of rounding to 5, 6, 10, 15 or 30 minutes before you decide to use it.
  • Converting by hand with a minutes table.

What's inside

How to use
Short instructions and the colour key.
Timesheet
The rounding step; 31 days with start, finish and unpaid break; each day in hours and minutes and in decimal hours; the same rounded to your step; and totals.
Minutes to decimal
Every minute from 0 to 59 as a decimal fraction of an hour.

Preview

Worked example: rounding step of 15 minutes
Date Start Finish Break Hours:minutes Decimal Rounded Rounded decimal
1 Mar 2027 09:07 12:03 0 2:56 2.93 3:00 3.00
2 Mar 2027 09:00 17:20 30 7:50 7.83 7:45 7.75

The two days total 10:46, or 10.77 decimal hours. Rounded to 15 minutes they total 10:45, or 10.75. With the step set to 1, nothing is rounded. Rounding is your own policy; check what is allowed where you work.

How to use it

  1. Choose the rounding step in minutes: 1 for none, or 5, 6, 10, 15 or 30.
  2. Each day, type the start and finish time and any unpaid break in minutes.
  3. Read the time in hours and minutes and in decimal hours, then the rounded versions.
  4. Check the totals at the bottom.
  5. To convert a time by hand, find the minutes on the Minutes to decimal sheet and add them to the hours.

The formulas, explained

Hours and minutes
=IF(OR(B7="",C7=""),"",MAX(0,MOD(C7-B7,1)-D7/1440))

Finish minus start, even after midnight, less the break. A day is 1440 minutes, so the break in minutes รท 1440 comes off a fraction of a day.

Decimal hours
=IF(E7="","",E7*24)

The fraction of a day times 24 is decimal hours.

Step used
=IF(N(B4)>=1,B4,1)

Your rounding step, or 1 (no rounding) when it is blank, 0 or not a number, so nothing divides by zero.

Rounded to your step
=IF(E7="","",INT(ROUND(E7*1440,6)/$B$5+0.5)*$B$5/1440)

Turns the day into minutes, divides by the step, rounds to the nearest whole step and turns it back. An exact half step rounds up: ROUND removes tiny arithmetic errors first, so 3 minutes on a 6 minute step is always 6 minutes, never 0.

Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.

Questions

How do I convert minutes to a decimal?

Divide the minutes by 60: 45 minutes is 0.75 and 20 minutes is 0.33. Add the hours, so 7 hours 50 minutes is 7.83. The Minutes to decimal sheet lists every minute.

Should I round to 15 minutes?

That is a policy choice, not something the file decides. Whether rounding is allowed, and how, depends on your country and agreement, and it can favour you or the employee. Compare the results here before you choose.

Why show both formats?

Staff read hours and minutes, but payroll and invoicing tools usually want decimals. Seeing both makes errors easy to spot.

How is this different from the timesheet calculator?

The calculator adds up hours in your browser. This is a file you keep, with a row for each day, a rounding step and a conversion table.

Does it work in Google Sheets?

Yes. Upload it with File > Import in Google Sheets. It only uses functions both programs have (IF, OR, MAX, MOD, INT, ROUND, N and SUM). It also opens in LibreOffice.

About this template

Last reviewed 15 November 2026.

Changes: 15 November 2026: first published.

Free to use and change in your own business. Please don't resell the files or publish them as your own. More free templates.

Track this in Jasper

Log hours by client and project, approve timesheets and follow retainer hours, next to your team chat.

Want this by email?

Entirely optional. Everything on this page works without an email address.

Sent by Shakewell Agency Pty Ltd, Sydney, Australia. Every email has an unsubscribe link. Privacy policy.