Converts a number of seconds into a string in the format of days.hours:minutes:seconds.

Function (NumberVar interval)
NumberVar Days := Truncate(interval / 86400);
NumberVar Hours := Truncate(Remainder(interval, 86400) / 3600);
NumberVar Minutes := Truncate(Remainder(interval, 3600) / 60);
NumberVar Seconds := Remainder(interval, 60);
Totext(Days,'##') +'.'+ Totext(Hours,'00') +':'+ Totext(Minutes,'00') +':'+ Totext(Seconds,'00')


Parameters

interval

The number of seconds to be converted.

Return Value

A string in the format of days.hours:minutes:seconds

Remarks

none

Example

//returns 0.00:02:12
ElapsedTime(132)

//formats the difference between two datetime values.
ElapsedTime ((CurrentDateTime-DateTime(2006,1,1,0,0,0))*86400)

//formats the difference between two datetime values.
ElapsedTime (DateDiff("s", {TABLE.FIELD}, CurrentDateTime))

Requirements

This function requires the use of Crystal Syntax.

Crystal Reports · Date/Time · Functions · Programming