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" docid\ u26v9fecfs6ilwa0 pvjd 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 $(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