Duration

The value derived from the function is a time value.

This table shows the commands and the related syntax used for the Duration data type:


Command	Syntax	Examples
Time Value	`?HH:MM:SS?`	`?12:12:12?` : 12 hours 12 minutes 12 seconds `?123:12:12?` : 123 hours 12 minutes 12 seconds `?123:12?` : 123 hours 12 minutes `?123?` : 123 hours
`TIME` This function converts a time string into a time value.	`TIME(<Time string>)`	`TIME("12:12:12") = ?12:12:12?`
`TIME STRING` This function converts the number of seconds into a time string.	`TIME STRING(<number of seconds>)`	`TIME STRING(60) = "00:01:00"` `TIME STRING(123456) = "34:17:45"` `TIME STRING(132465789) = "34293:33:09"`
`TimeLen2Hr` This function converts the number of minutes to a time value.	`TimeLen2Hr(<number of minutes>)`	`TimeLen2Hr(1) = ?00:01:00?` `TimeLen2Hr(60) = ?01:00:00?` `TimeLen2Hr(1450) = ?24:10:00?` `TimeLen2Hr(10000) = ?166:40:00?`
Operators These operators can be used here: + - * / \ %	Time + Time = Time Time - Time = Time Time * Integer = Integer Time / Integer = Integer Time \ Integer = Integer Time % Number = Number The operators that return an integer value can only be used in a function if the result (number of seconds) is converted to a time value.	`?02:03:04? + ?01:02:03? = ?03:05:07?` `?02:03:04? - ?01:02:03? = ?01:01:01?` `?02:03:04? + 65 = 7449` `?02:03:04? - 65 = 7319` `?02:03:04? * 2 = 14768` `?02:03:04? / 2 = 3692` `?02:03:04? \ 2 = 3692` `?02:03:04? % 2 = 0`