Page 1 of 1
Converting numeric to hh:mm:ss
Posted: Wed May 05, 2004 12:40 pm
by 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.
=> RE: Converting numeric to hh:mm:ss
Posted: Thu May 06, 2004 7:02 am
by 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
==> RE: Converting numeric to hh:mm:ss
Posted: Thu May 06, 2004 11:37 am
by 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
===> RE: Converting numeric to hh:mm:ss
Posted: Thu May 06, 2004 1:00 pm
by 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