Convert milliseconds field into mm:ss 2

[balllian]

I have the following field which is milliseconds but i want to convert this to mm:ss

eg. 165612

How i can do this, has anyone done this before.

Thanks inadvance
Ian

 

[PHV]

You may use the following expression:
Format([milliseconds]/86400000,'nn:ss')

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[balllian]

Thanks for this.

Next step.When i run a make table query with the above it transfers as text I want it to transfer as mm:ss. How i can ensure that it goes as mm:ss and not text.

Thanks In advance

 

[Golom]

Sorry but "mm:ss" IS text. Numbers don't support characters like ":".

 

[balllian]

ok. im looking to transfer milliseconds ie 165612 into a time format which will be hhmmss.

i have used this below so far but need this to be as described above.

Format([milliseconds]/86400000,'nn:ss')

Any ideas

 

[Golom]

Transfer it as

CDate([milliseconds]/86400000)