Miliseconds Into Minutes

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9470-miliseconds-into-minutes.html
creating but can't find an easy solution to converting the miliseconds iTunes
uses into a user friendly minutes. Thanks for the help.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9470
--
Robert

*

Do you agree or disagree with the writer above? Why not share your immediate thoughts with us! Login Now! or Sign Up Today! to share your views... Gurfateh!

=[YourField]/ (1000 * 60)

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

"Robert J" wrote:

> Hi folks. First, I just wanted to say thanks to all of you who helped me
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9470
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9470
> 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.
> --
> Robert

On Thu, 11 May 2006 15:31:01 -0700, Robert J
wrote:

>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).
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9470
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9470
>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]