msec - sec

[mik706]

I know this should be simple but i have had a long day and i have lost the ability to think.

I have a time value in mSecs. i want to convert this value into whole seconds and the remaining mSecs so i can display the values returned in a more user friendly manner.

Thanks in advance

[nareth]

Seconds = int(MSeconds / 1000)
MSeconds = MSeconds - Seconds * 1000

there ya go

[techgnome]

Originally posted by nareth
Seconds = int(MSeconds / 1000)
MSeconds = MSeconds - Seconds * 1000

there ya go

I'd use CLng rather than Ints as MSeconds can be really large.

Seconds = Clng(MSeconds \ 1000)
MSeconds = MSeconds - Seconds * 1000

Also by flipping the / to \ that will force it to use integer (whole number) division rather than floating point (which will return a decimal). This will make it more accurate.

TG

[nareth]

i thought int removed decimals... what does int actually do? just convert to integer? i thought cint() did that

[techgnome]

Originally posted by nareth
i thought int removed decimals... what does int actually do? just convert to integer? i thought cint() did that

It rounds off, which can lead to innacurate results (it does some funky things when rounding.) The best way to remove decimals is to not have them in the first place.

TG