TIMEDIF – Find Durations in Hours, Minutes, Seconds, etc.

Say goodbye to complex formulas and time-consuming calculations. TIMEDIF, a powerful Google Sheets add-on, simplifies the process of determining time differences and durations, making it an essential tool for project management, scheduling, and time tracking.

With TIMEDIF, you can:

  • Accurately calculate the difference between two times across different days.
  • Efficiently determine the duration of events, tasks, or projects.
  • Flexibly choose the desired output format, including years, months, weeks, days, hours, minutes, seconds, or milliseconds.
  • Easily integrate TIMEDIF into your existing spreadsheets for seamless calculations.

Unleash the Power of TIMEDIF

Whether you’re managing project timelines, tracking employee hours, or production times, TIMEDIF streamlines your workflow and eliminates the hassle of manual calculations.

Key Features:

  • Intuitive interface: TIMEDIF’s user-friendly design makes it easy to navigate and use, even for those with limited spreadsheet experience.
  • Versatility: Calculate time differences for various applications, from project management to employee timesheets.
  • Customizable output: Choose the desired time units to suit your specific needs.
  • Seamless integration: Effortlessly incorporate TIMEDIF into your existing spreadsheets.

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. Then, choose the units for the output and click the “Calculate from form ⬆️” button.

TIMEDIF sidebar with datetimes
TIMEDIF sidebar showing output choices

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 using the sidebar.

Embrace efficiency and accuracy with TIMEDIF. Download the add-on today and experience the power of simplified time calculations.

YouTube Instructional Videos

YouTube player
How to Use TIMEDIF
YouTube player
How to Install TIMEDIF


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

Multiple User Pricing

We offer the following discounts for multiple users in the same organization. Contact us before you checkout. 

QuantityUnit Price
2 – 10$9
11 – 50$5
51 – 200$3
201 +$2


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.

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.

Terms of Service Privacy Policy Contact