Calendar Timesheet

Billable hours calculator

Convert hours and minutes to decimal hours, round each entry up to 6 or 15 minutes, add a minimum and an hourly rate. Free, in your browser.

Type one duration per line to see the result.

Your meetings are already in Google Calendar? The free Google Calendar hours calculator adds them up from your calendar export, and the free Calendar Timesheet sheet applies these rounding rules to every meeting, every month; Pro adds rates and month-end statements.

Get the free sheet

How the rounding works

Each entry is rounded up to the next step, then the minimum applies: with 15-minute rounding and a 30-minute minimum, a 5-minute call bills 30 minutes and a 37-minute call bills 45. Rounding each entry gives a higher total than rounding the month once; the calculator shows both, so you can choose the rule to write in your quote. The guide to billing clients from Google Calendar explains which rule fits which client.

Decimal hours are minutes divided by 60: 37 minutes is 37 ÷ 60 = 0.62 hours. Billing in tenths of an hour, common with lawyers and consultants, rounds each entry up to the next 6 minutes.

Minutes to decimal hours

MinutesHoursMinutesHoursMinutesHoursMinutesHours
10.02160.27310.52460.77
20.03170.28320.53470.78
30.05180.30330.55480.80
40.07190.32340.57490.82
50.08200.33350.58500.83
60.10210.35360.60510.85
70.12220.37370.62520.87
80.13230.38380.63530.88
90.15240.40390.65540.90
100.17250.42400.67550.92
110.18260.43410.68560.93
120.20270.45420.70570.95
130.22280.47430.72580.97
140.23290.48440.73590.98
150.25300.50450.75601.00

6-minute increments chart

Minutes workedBilled (hours)
1–60.1
7–120.2
13–180.3
19–240.4
25–300.5
31–360.6
37–420.7
43–480.8
49–540.9
55–601.0

Questions

How do I convert minutes to decimal hours?

Divide the minutes by 60. 15 minutes is 0.25 hours, 20 minutes is 0.33, 45 minutes is 0.75. In a spreadsheet, a duration stored as a time (1:30) becomes decimal hours with =A2*24.

What are 6-minute increments?

Billing in tenths of an hour: every started block of 6 minutes counts as 0.1 hours. A 7-minute call bills 0.2 hours, a 13-minute call 0.3.

Should I round each entry or the total?

Most professionals round each entry and say so in their quote or contract. Whatever you choose, apply the same rule every month. The table above shows the difference for your own entries.

Can it take my hours from Google Calendar?

This calculator works on what you type. To total the hours already in your calendar, use the Google Calendar hours calculator; to have them rounded and billed every month, Calendar Timesheet does it in Google Sheets.