relativetime PowerHome formula function
Description
Obtains a time that occurs a specified number of seconds after or before another time within a 24-hour period.
See the
Date / Time Functions section for detailed information concerning date / time formats.
Syntax
relativetime ( time, n )
Argument |
Description |
time
|
A time value
|
n
|
A long number of seconds
{Fractional seconds are not supported} |
Return value
Time. Returns the time that occurs n seconds after time if n is greater than 0. Returns the time that occurs n seconds before time if n is less than 0. The maximum return value is 23:59:59.
Examples
The following examples demonstrate typical syntax/usage for this function.
• ph_relativetime(now(), 10)--> evaluates to: 16:43:21:173
• ph_relativetime(15:00:00, 20) --> evaluates to: 15:00:20