Work out the time between two timestamps — even when they fall on different days.

Google Sheets™ makes overnight time math awkward: subtract a Tuesday 2:00 AM from a Monday 10:00 PM and you get a negative number or an error. TIMEDIF handles it correctly, every time, with no formula to write.

HOW IT WORKS

1. Select the range holding your start and end date-times — or type them straight into the sidebar.
2. Choose the units you want back.
3. Click go. The results land beside your data.

CHOOSE YOUR OUTPUT UNITS

Years, months, days, hours, minutes, seconds, or milliseconds. Pick whichever the job needs — payroll wants hours, a process audit might want seconds.

PERFECT FOR
✓ Timesheets and payroll — hours worked across overnight and split shifts
✓ Shift scheduling — nurses, security, hospitality, manufacturing, anything that crosses midnight
✓ Project tracking — elapsed time from start to finish, in days or hours
✓ Event planning — duration between a setup time and a close time
✓ SLA and response times — how long a ticket actually stayed open
✓ Research and lab work — precise elapsed intervals down to milliseconds

WHY NOT JUST SUBTRACT?

A plain subtraction works only when both times fall on the same day. The moment a shift runs past midnight, or a task spans a weekend, it breaks — and it breaks quietly, which is worse. TIMEDIF reads the full date and time on both ends, so the answer is right whether the gap is twenty minutes or three months.

PRICING

7-day free trial, then $9 per year. No credit card to start.

Questions? Visit sheetshelp.com/contact

—
Google Sheets™ is a trademark of Google LLC. TIMEDIF is an independent add-on and is not endorsed by or affiliated with Google LLC.