SecondsToTime
Converts a number of seconds to the equivalent duration in the form dd:hh:mm:ss.
Syntax
SecondsToTime(value)
Enabled for
| Search/Dashboard | Yes |
| Business Rules | Yes |
| Quick Actions | Yes |
| Workflow Objects | Yes |
| Reports | No |
Parameters
| value | The number of seconds to be converted. |
Return Value
Text value of the form dd:hh:mm:ss. For example, 06:06:55:58.
- For durations less than one day, the dd: is omitted.
- For durations less than one hour, the hh: is also omitted.
- For durations less than one minute, the mm: is also omitted.
Example
To find the difference between the created date and time and the last modified date and time, use the following example:
$(SecondsToTime(DateDiff("second", ToString(LastModDateTime), ToString(CreatedDateTime))))
In this example, the DateDiff() function is used to compute the difference in seconds between the LastModDateTime and CreatedDateTime times. The function then converts the seconds to a text value in the dd:hh:mm:ss format.