texttimedifference(
START
,
END
)
The texttimedifference( function allows time math to be performed on text values.
Parameters
This function has two parameters:
start – The starting point of the time interval.
end – The ending point of the time interval.
Description
This function allows time math to be performed on text values (use the timedifference( function when working with numeric time values). The parameters and result are all text.
texttimedifference("9:45 AM","12:20 PM") ☞ 2:35:00
texttimedifference("2:10:37 PM","7:50:09 PM") ☞ 5:39:32
texttimedifference("2:10:37 PM","7:50:09 AM") ☞ -6:20:28
If you need to calculate the difference between two times that cross midnight, use the texttimeinterval( function. If you need to calculate time differences across multiple days, use SuperDates (see superdate().
Note: This function is equivalent to:
timepattern(timedifference(time(start),time(end)),"hh:mm:ss")
See Also
- converttimezone( -- converts a time or superdate from one time zone to another.
- daylightsavingstimeoffset( -- returns the current daylight saving time offset of the specified time zone.
- info("localtimezone") -- returns the local time zone for the current location of your computer.
- info("milliseconds") -- returns the number of milliseconds (1/1000th second) since the system started up.
- info("tickcount") -- returns the number of ticks (1/60th second) since the system started up.
- info("timezoneabbreviations") -- returns a dictionary of time zone abbreviations supported by the system.
- info("timezones") -- returns a list of time zone regions recognized by the system.
- longtimestr( -- converts a number to text in am/pm time format, including seconds.
- nextdaylightsavingstimetransition( -- returns the next date on which a transition to or from daylight savings time occurs.
- now( -- returns the current time (number of seconds since midnight).
- regulartime( -- extracts a regular time (seconds since midnight) from a superdate.
- secsminshours( -- this converts a time (number of seconds) into an approximate text value.
- superdate( -- converts a regular date and a regular time into a superdate.
- superdatepattern( -- converts a number containing a superdate to text, allowing you to specify the patterns for both the date and the time conversion to text.
- superdatesecondsstr( -- converts a number containing a superdate to text, including the seconds.
- superdatestr( -- converts a number containing a superdate (date + time) to text.
- supernow( -- returns the number representing the current date and time as a superdate.
- texttimeinterval( -- allows time math to be performed on text values.
- time( -- converts text into a number representing a time.
- time24( -- takes a time and makes sure it falls within a 24 hour period.
- timedifference( -- calculates the difference between two times. It works correctly even if the interval between the two times crosses over midnight.
- timeinterval( -- calculates the time interval between two times. It works correctly even if the interval between the two times crosses over midnight.
- timepattern( -- converts a number representing a time into text. The function uses a pattern to control how the time is formatted.
- timestr( -- converts a number to text in am/pm time format.
- timezoneabbreviation( -- returns the abbreviation of the specified time zone.
- timezonename( -- returns the continent and city of the specified time zone.
History
| 10.0 | No Change | Carried over from Panorama 6.0. |