Converting numeric to hh:mm:ss

[Brad_Wells_(Guest)]

Can someone help me with converting a numeric 999999999 to hh:dd:ss format?____I am unsure how to handle this using calculated field, or more likely fields.

[kfleming]

Is the numeric a serial number (representing the elapsed time since a particular date) or is it mmddyyyy as a numeric?____Kathleen__R&R Support

[Brad_Wells_(Guest)]

It is a number that is in seconds. Example 90 would convert to 1:30______Also, is there now a way to have a control files output to html?____Thanks,____Brad

[kfleming]

Try:__str(int(sec/3600),2)+":"+str(int(mod(sec,3600)/60),2)+":"+__str(int(mod(mod(sec,3600),60)),2)____where sec is the name of your numeric field.____To output to html you can set__RI_PRINTER=H__RI_OUTFILE=myfile.html______Regards,__Kathleen__R&R Support