Seconds to dd:hh:mm:ss

[TrentSteel]

All

I know that one of the FAQ's does have a formula like this:

whileprintingrecords;

numberVar dur:={TIME_TO_FINISH}(this is where error occurs)
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;

hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);

hhmmss := totext(hrs, "0") + ":" + totext(min, "00") + ":" + totext(sec, "00");

hhmmss

but it is not working for me. I get error that from the point indicated in the above code, it gives me "the remaining text is not part of the formula.

Also, I tried getting it to display dd:mm:hh:ss, but I just can't get it to work. Has someone else got this? TIA

Trent - using Crystal 8.5

 

[KingfisherINC]

numberVar dur:={TIME_TO_FINISH}[COLOR=red yellow];[/color] //(this is where error occurs)


Kingfisher

 

[lbass]

Here is an adaptation of Synapsevampire's conversion formula that adds in days.

numberVar dur := {TIME_TO_FINISH}; //assuming field is in seconds
numberVar days;
numberVar hrs;
numberVar min;
numberVar sec;
stringVar ddhhmmss;

days := Truncate(dur/86400);
hrs := Truncate(Remainder(dur,86400)/3600);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);

ddhhmmss := totext(days,"00")+ ":"+totext(hrs, "00") + ":" +
totext(min, "00") + ":" + totext(sec, "00");

ddhhmmss;

-LB

 

[TrentSteel]

LB & KingfisherINC,

I figured it out after a few rounds of trial and error, but thanks all the same, it helped me clean mine up. Another addition to the knowledge base I suppose.

Thanks again!

-TS