Converting SECONDS to Hours:Minutes:Seconds 1

[LeonelSanchezJr]

I have an field which holds the average amount of seconds that a process took.

How do I convert this field into HOURS, MINUTES and SECONDS?

Example:


Seconds = 95

Converted to HH:MM:SS would be: 00:01:35

 

[jjames]

In a formula field....


NumberVar Hours := Truncate(SECONDS_FIELD / (60 * 60));
NumberVar Minutes := Truncate((SECONDS_FIELD - (60 * 60 * Hours)) / 60);
NumberVar Seconds := SECONDS_FIELD - ((60 * 60 * Hours) + (60 * Minutes));

TimeSerial(Hours,Minutes,Seconds)