Time formatting 1

[ddrake]

Hi all,
I've got a report that calculates a bunch of time entries in just a standard numerical format (ex. 200 hours). What I need to do is format this number in a format like Excel (00:00:00 (so for the above example, it would look like this (200:00:00) (hh:mm:ss)). Is there a way to do this that I'm missing? Thanks!

Dave

CR9, ARS 5.12, SQL2K, WinServer

 

[ddrake]

Addendum - Might be helpful if I provide the formulae that's calculating the time differential:

({HPD_HelpDesk.Resolved Time} - {HPD_HelpDesk.Last Routed To Date})*24

Where the difference between the two fields is returned as a decimal equating to portions of an hour (ex. .01 = 11 minutes) and then multiplied by 24 for hours.

 

[GJParker]

the easiest way is to convert to a string i.e.

cstr({MyTable.MyField},0,"") + ":00:00"

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[lbass]

Howard Hammerman's faq149-1215 might help.

-LB

 

[ddrake]

Brilliant!! Thank you!