Miliseconds Into Minutes

[Robert J]

Hi folks. First, I just wanted to say thanks to all of you who helped me
with the subform question. Now, to the good stuff. I'm currently exporting
data from an application that I uses to play my digital music (read iTunes).
One of the fields is for track legnth, but iTunes keeps track of this info in
miliseconds, not minutes. I want to include the track legnth in a table i'm
creating but can't find an easy solution to converting the miliseconds iTunes
uses into a user friendly minutes. Thanks for the help.

 

[KARL DEWEY]

=[YourField]/ (1000 * 60)

1000 miliseconds equal one second and 60 seconds equal one minute.

 

[John Vinson]

Hi folks. First, I just wanted to say thanks to all of you who helped me
with the subform question. Now, to the good stuff. I'm currently exporting
data from an application that I uses to play my digital music (read iTunes).
One of the fields is for track legnth, but iTunes keeps track of this info in
miliseconds, not minutes. I want to include the track legnth in a table i'm
creating but can't find an easy solution to converting the miliseconds iTunes
uses into a user friendly minutes. Thanks for the help.

If you'ld like it in minutes and seconds - e.g. 3:42 - rather than the
less clear 3.70 minutes, try an expression like

[TrackLength] \ 60000 & Format([TrackLength] \ 1000 MOD 60, "\:00")

John W. Vinson[MVP]