Date Time Duration

Get elapsed time in Excel, with millisecond accuracy. The DATETIMEDURATION formula calculates exact time or date units. Returns years, months, days, or the fractional hours, minutes, seconds between two dates or two times. A more precise alternative to the DATEDIF formula. Perfect for timestamped files, SCADA logs, time series data or cumulative hour calculations. Simply supply the start time and end time, along with the desired time unit result.