SecondsToTime

Converts a number of seconds to the equivalent duration in the form dd:hh:mm:ss.

Syntax

SecondsToTime(value)

Enabled For

For a description of the business object categories, see Notes on "Enabled For".

Business Object Category Yes/No
Business Rules: Before-Save Rules Yes
Business Rules: Calculation Rules (After Save, with or without Also Recalculate on Load) Yes
Business Rules: Calculation Rules (Before Save or Always, without Also Recalculate On Load) Yes
Business Rules: Calculation Rules (Before Save or Always, with Recalculate On Load) Yes
Business Rules: Editing Rules Yes1
Business Rules: Initialization Rules Yes
Business Rules: Read Only Rules No
Business Rules: Required Rules Yes1
Business Rules: Validation Rules Yes1
Client Expressions No
Object Permissions No
Services Yes
LDAP Yes
Mobile Yes
Quick Actions (except UI Quick Actions) Yes
UI Quick Actions No
Reports Yes
Search/Dashboard without field references Yes
Search/Dashboard with field references No
1. Except when this field appears on a form or is triggered by such a field.

Parameters

Parameter Description
value The number of seconds to be converted.

Return Value

Text value in the following format 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:

Copy
$(SecondsToTime(DiffSeconds(CreatedDateTime, LastModDateTime)))

In this example, the DiffSeconds() function is used to compute the difference in seconds between the value of the CreatedDateTime and LastModDateTime times. The function then converts the seconds to a text value in the dd:hh:mm:ss format. Note that DiffSeconds takes the older datetime first.