Hours worked, time differences and business days in Google Sheets — without writing a formula. Select your start and end times, tick the units you want, and TIMEDIF writes the answer beside your data: 8.5 hours, 3 business days, 4 hours, or 2 years, 3 months, 14 days.
- Overnight shifts just work. 10:00 PM to 6:00 AM is 8 hours, even with no dates in the cells.
- Leave out weekends. Friday 5 PM to Monday 9 AM is 16 business hours, not 64.
- Timesheet columns that add up. Tick Write a number and you get 8.5 in the cell, ready to SUM or multiply by a pay rate.
- Any mix of units. Years, months, weeks, days, hours, minutes, seconds or milliseconds.
Why not just subtract?
Subtracting two times in Sheets works until it doesn’t. A shift that ends after midnight comes out negative. Typed times with no date can’t tell which one came first. And there is no built-in way to drop Saturdays and Sundays from a span that has times of day in it.
TIMEDIF handles all of these the same way every time, so a column of a hundred shifts gets a hundred right answers.
| You have | Sheets says | TIMEDIF says |
|---|---|---|
| 10:00 PM → 6:00 AM | -16 hours | 8 hours |
| Fri 5:00 PM → Mon 9:00 AM, weekdays only | 64 hours | 16 hours |
| 9:00 AM → 5:30 PM as a number | 0.354166… | 8.5 |
How to use it
A whole column at once
- Put start times in one column and end times in the column to its right.
- Select both columns. A header row is fine: TIMEDIF skips anything that isn’t a date or time.
- In the TIMEDIF side panel, tick the units you want. Tick Exclude Saturdays/Sundays for business time, or Write a number for a single summable number.
- Click Calculate active range. Results go in the next column to the right. If that column already has something in it, TIMEDIF asks before replacing it.
One answer in the side panel
Pick a start and end date and time in the side panel, tick your units, and click Calculate from form. The answer appears in the panel, with both times shown so you can check what was read.
Who uses it
- Timesheets and payroll — hours worked per shift, including night shifts, as numbers you can total.
- Service levels — how many business hours a ticket or order stayed open.
- Projects and deadlines — business days between milestones.
- Ages and tenure — years, months and days between two dates.
YouTube Instructional Videos
Pricing
Free to start, no credit card. Everything is unlimited for the first 7 days.
After that, the side panel calculator stays free and Calculate active range fills 10 rows per run. To fill whole columns in one click, subscribe for $9 per year. Please pay with the same email address you use in Google Sheets.
Multiple User Pricing
We offer the following discounts for multiple users in the same organization. Contact us before you checkout.
| Quantity | Unit Price |
|---|---|
| 2 – 10 | $9 |
| 11 – 50 | $5 |
| 51 – 200 | $3 |
| 201 + | $2 |
FAQ
Does it change my start and end times?
No. TIMEDIF only reads the two columns you select and writes into the column to their right. If that column already holds anything TIMEDIF didn’t write, it asks before replacing it.
Can I get a number instead of words?
Yes. Tick Write a number and tick one unit, such as Hours. Each cell gets a real number, like 8.5, so SUM and pay-rate formulas work. An end time before the start time gives a negative number.
How does it treat daylight saving time?
It counts clock time, the way your sheet shows it. Mar 1 to Apr 1 is 31 days. A shift across the night the clocks change is measured by the clock on the wall, the same as subtracting the two times in Sheets.
Are there limits on how much I can use it?
During the trial and with a subscription, the only limits are the daily quotas Google sets for every add-on. After the trial without a subscription, each range run fills 10 rows.
TIMEDIF says it is missing a permission. What do I do?
A box was unticked when it was installed. Click the link in the TIMEDIF panel, tick Select all, click Continue, and reload the spreadsheet.
How do I solve the Permission Denied error code?
The error message “We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED.” occurs when a user is logged into multiple Google accounts. Log out of all other Google accounts, restart your browser, and start the add-on again.
How do I use the add-on with my iPad?
Open your Google Sheet in the Safari web browser instead of Chrome or the Sheets mobile app. If you still do not see the full version of Google Sheets, go to Settings, then Safari, and select Request desktop website. Toggle this setting to on.
Subscriber Portal | Terms of Service | Privacy Policy | Contact