TIMEDIF – Date and Time Duration – Google Sheets Add On

TIMEDIF is a Google Sheets add-on that calculates the difference between two times on different days. It is helpful for tracking hours worked, project duration, or event scheduling.

It’s easy to use – select the range of cells with dates and times or enter them directly into the sidebar.

Choose the output units: years, months, days, hours, minutes, seconds, or milliseconds.

app icon for TIMEDIF with a calendar and clock
TIMEDIF sidebar

Two Methods

You can provide the starting and ending times using two methods – inside your spreadsheet or in the sidebar.

In the Spreadsheet

TIMEDIF can use times from your spreadsheet and write the output into an adjacent cell.

  • Select the range with the dates and times
  • Choose which output units you want
    • Years, months, weeks, days, hours, minutes, seconds, and milliseconds
  • Press Calculate active range.

In the Sidebar

You can perform all of your calculations without leaving the sidebar.

First, enter the start and end times. We’ll start at 3:00 pm on April 24, 2022, and end at 4:15 pm on February 5, 2023.

TIMEDIF sidebar with datetimes
Start and End Times

Choose the units for the output and click the “Calculate from form ⬆️” button.

TIMEDIF sidebar showing output choices
Output Units and Calculate Buttons

TIMEDIF shows the output in the desired units.

The duration output in the desired units
Output in Desired Units

These are the only steps to arrive at the time passed between two times on different days.


The TIMEDIF add-on is free for seven days, then $14 for a lifetime license. No subscription is needed.


Are there limitations on the usage of this app?

TIMEDIF functions per the daily quotas Google imposes on all add-ons and apps. These quotas limit the app’s run time per request and an overall daily run time. The limits are the same in the free and paid versions of TIMEDIF.

Leave a Comment