converting time from seconds back to hh:mm:ss 2

[cmacd]

I need help with converting a time field from seconds back to hh:mm:ss

Thanks,
CMacD

 

[dbielenda]

I used this formula when trying to format my date fields, perhaps this may help with the time?

(Left(Right((IIF((Length(Replace (ToText({TABLENAME.FIELD},0),&quot;,&quot;,&quot;&quot))<6, &quot;0&quot;
+ (Replace (ToText({TABLENAME.FIELD},0),&quot;,&quot;,&quot;&quot), (Replace (ToText({TABLENAME.FIELD},0),&quot;,&quot;,&quot;&quot))),6),2))

+ &quot;:&quot;

+ (Left(Right((IIF((Length(Replace (ToText({TABLENAME.FIELD},0),&quot;,&quot;,&quot;&quot))<6, &quot;0&quot;
+ (Replace (ToText({TABLENAME.FIELD},0),&quot;,&quot;,&quot;&quot), (Replace (ToText({TABLENAME.FIELD},0),&quot;,&quot;,&quot;&quot))),4),2))

+ &quot;:&quot;

+ (Right((IIF((Length(Replace (ToText({TABLENAME.FIELD},0),&quot;,&quot;,&quot;&quot))<6, &quot;0&quot;
+ (Replace (ToText({TABLENAME.FIELD},0),&quot;,&quot;,&quot;&quot), (Replace (ToText({TABLENAME.FIELD},0),&quot;,&quot;,&quot;&quot))),2))

 

[kenhamady]

I think there is a formula in my FAQ that will do this: faq149-243 Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/