convert decimal value to hh:mm:ss

[mbryantuk]

Hi

I have a field storing the amount of seconds to perform an action e.g. 20.25 seconds is it possible to convert this to HH:mm:ss in crystal

Thanks

 

[IanWaterman]

use a formula

totext(int({secondsfield}/3600),0,"")&':'&
totext(int(remainder(({secondsfield}/3600),60)),0,"")&':'&
totext(int(remainder(remainder(({secondsfield}/3600),60),60)),0,"")

Ian

 

[IanWaterman]

sorry that should have been

use a formula

totext(int({secondsfield}/3600),0,"")&':'&
totext(int(remainder(remainder({secondsfield},3600),60)),0,"")&':'&
totext(int(remainder(remainder(remainder({secondsfield},3600),60),60)),0,"")

Ian

 

[IanWaterman]

I'll get it right in a minute

totext(int(10000/3600),"00",0,"")&':'&
totext(int(remainder(10000,3600)/60),"00",0,"")&':'&
totext(int(remainder(remainder(10000,3600),60)),"00",0,"")

Ian