Instructions

Table of Contents

How to install

How to use

How to adjust security

How to uninstall

Version 2.0

Windows XP?

See version 1.0

DATETIMEDURATION calculates elapsed time in Excel.

How To Install

  1. To install Date Time Duration, first download the free trial.
  2. Ensure the downloaded file is not being “blocked”, as follows:
    • a ) From Windows File Explorer, go to your “Downloads” folder.
    • b ) Right-click the DateTimeDurationSetup.zip file, select Properties.
    • c ) If you see an Unblock checkbox, check Unblock, then OK:

3. Unzip the DateTimeDurationSetup.zip file, then open the DateTimeDurationSetup.msi file. Click Next:

  1. If you agree, check I accept the terms of the License Agreement, then click Next:
  1. If desired, click Change… to change the install folder. Click Next:
  1. Click Install:
  1. Click Finish:

That’s it!

How To Use

  1. Open your Excel workbook.
  2. In your desired cell, type the following formula:

=DATETIMEDURATION(start_datetime, end_datetime, Unit)

Note: Excel may not show this formula or its arguments. However, if you type it, it will work perfectly.

The arguments of the formula are as follows:

start_datetime:
The starting time (or date).

end_datetime:
The ending time (or date).

Unit:
The desired unit of time (or date). The unit may be one of the following:

  • “ms” for milliseconds
  • “s” for seconds
  • “n” for minutes
  • “h” for hours
  • “d” for days
  • “m” for months
  • “y” for years

EXAMPLE #1 – Time elapsed, in milliseconds

Suppose you have a start time in cell B3, and an end time in cell C3. To calculate the number of milliseconds between the start & end time, use the formula:

=DATETIMEDURATION(B3, C3, “ms”)

  • click to zoom EXAMPLE #1

EXAMPLE #2 – Time elapsed, in hours

Suppose you have a start time in cell B3, and an end time in cell C3. To calculate the number of hours between the start & end time, use the formula:

=DATETIMEDURATION(B3, C3, “h”)

  • click to zoom EXAMPLE #2

EXAMPLE #3 – Number of days between two dates

Suppose you have a start date in cell B3, and an end date in cell C3. To calculate the number of days between the start & end date, use the formula:

=DATETIMEDURATION(B3, C3, “d”)

  • click to zoom EXAMPLE #3

That’s it!

How To Adjust Security

If you have our software installed but it is not working as expected, your Office security settings may need to be configured:

  1.  Open Microsoft Excel, then select the File menu, Options (your version may differ):
  1. In the left pane, select Trust Center, then click Trust Center Settings…:
  1. In the left pane, select Add-ins. Uncheck Disable all Application Add-ins. It is recommended to also uncheck Require Application Add-ins to be signed by Trusted Publisher, otherwise you will be prompted to enable the DateTimeDuration add-in:
  1. Close and re-open Office.
  2. If prompted to enable the DateTimeDuration add-in, click Enable this add-in…, then click OK:

That’s it!

If you still experience issues, you may need to uninstall then re-install Date Time Duration, or contact us.

How To Uninstall

To remove Date Time Duration from your computer:

  1.  In Windows, go to Add or remove programs:
  1. Scroll and select Date Time Duration, then click Uninstall:

That’s it!

Having trouble? Try our FAQ Support section or contact us!