Integer to Time format 1

[Anesthaesia]

I need to convert an integer to time format ie. 127.8347 would be 2:07.8347

I have found examples that convert to hh:mm:ss but do not allow for milliseconds.

Any help would be great.

 

[Golom]

This seems to do it

x = 127.8347
? Format(x \ 60,"00") & ":" 
  Format(Int(x) Mod 60,"00") & "." & 
  Format(10000 * (x - int(x)),"0000")
02:07.8347

VB.Net has a Format character "f" as in

Format ( SomeTime, "hh:nn:ss.ffff" )

That will do that but it doesn't seem to be supported in VB6.

 

[johnwm]

What type of Integer is 127.8347?

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[BobRodes]

Let's see. I think it's a "fixed point integer" variable. yeah, that's it.....

 

[tsh73]

BobRodes,
please elaborate. Now you just puzzled me beyond words...

 

[johnwm]

Maybe Bob and I should have used the symbol to make it clear that it was a joke. An integer is by definition a whole number, so can't have a decimal point

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[BobRodes]

I wanted to use that, but couldn't find it. But really, I was half serious.

The Currency type is actually stored internally as a 64 bit "scaled" integer. Scaling simply means that a correction factor (in the case of the Currency type, the factor is .0001) is applied to the integer at point of access.

For more info:

http://support.microsoft.com/kb/189862

Bob

 

[harebrain]

An integer is by definition a whole number,...

To put a fine point on it, no, it isn't. Negative numbers are not, by definition, whole numbers. Whole numbers are defined as the non-negative subset of integers. Integers are the counting numbers, their negatives, and zero. Except for the size restriction, the integer datatype in VB corresponds to the mathematical definition.

Some languages, such as Pascal, draw the distinction with integer datatypes and cardinal (whole number) datatypes.