Date difference in hh.mm.ss

[ipazzo]

I have two filed a start date/time "hbeg" and an end date/time "hend".
Is there a way to use a formula to have the difference in the hh.mm.ss format?

Thanks for any suggestion.

 

[Naith]

The simplest way would be to download the DateTimeDiff UFL from Crystal's support site and use that.

Alternatively, use a formula like the following:

WhilePrintingRecords;
NumberVar SecondsDiff := DateDiff('s',{hbeg},{hend});
NumberVar Hours;
NumberVar Mins;
NumberVar Secs;

Hours := truncate(secondsdiff/3600);
Mins := truncate(((SecondsDiff/3600) - Hours)*60);
Secs := truncate(((((SecondsDiff/3600) - Hours)*60) - Mins)*60);

ToText(Time(Hours,Mins,Secs),"hh:mm:ss"

Naith