Howdy,

I need to convert a number that represents a big pile of milliseconds from a start time into HH:MM:SS.hh (hh being hundreds of seconds).

Is there a more elegant way of doing it than a bunch of division with If..Then statements?

Thanks!

Howdy,

I need to convert a number that represents a big pile of milliseconds from a start time into HH:MM:SS.hh (hh being hundreds of seconds).

Is there a more elegant way of doing it than a bunch of division with If..Then statements?

Thanks!

"hundredths of seconds", that is.

Is there any way to force this to display the two hundredths digits, even if they're zeros? It will look better on the report. Fixed number of decimals doesn't work. I made it work by extracting the third character from the right and performing concatenations based on that value, but you know, there might be a more elegant way to do that.

Thanks!

GetAsTime ( Div ( milliseconds ; 10 ) / 100 )