timedifference(
STARTTIME
,
ENDTIME
)

The timedifference( function calculates the difference between two times. It works correctly even if the interval between the two times crosses over midnight.


Parameters

This function has two parameters:

starttime – is a number (number of seconds) representing the starting point of the time interval.

endtime – is a number (number of seconds) representing the ending point of the time interval.


Description

The timedifference( function calculates the time interval between two times. It works correctly even if the interval between the two times crosses over midnight. This function returns a time interval between –12 and +12 hours. See also the timeinterval( function, which returns a time interval between 0 and +24 hours.

If the end time is later in the same day as the start time, the result of the function is the same as subtracting the start time from the end time:

timepattern(timedifference(time("205a"), time("930a")),"hh:mm") ☞ 7:25

If the end time is in the next day, the function adjusts for the fact that the interval crosses over midnight:

timepattern(timeinterval(time("930p"), time("205a")),"hh:mm") ☞ 4:35       

If the end time is earlier than the start time, a negative value is returned. This is true even if the time interval crosses midnight.

timepattern(timedifference(time("930a"), time("205a")),"hh:mm") ☞ -7:25
timepattern(timeinterval(time("205a"), time("930p")),"hh:mm") ☞ -4:35       

Note: The timeinterval( function assumes that the interval is no more than 12 hours positive or negative. If you need to compute timeinterval that cross over multiple days you must use SuperDates, which combine both date and time into a single value.


See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0