Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Miliseconds Into Minutes

Discussion in 'Information Technology' started by Robert J, Jul 28, 2006.

  1. Robert J

    Robert J
    Expand Collapse
    Guest

    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.
    --
    Robert
     
  2. Loading...

    Similar Threads Forum Date
    'punj mint' The different hues five minutes can adopt Inspirational Stories Feb 8, 2013
    India Delhi gang-rape victim's friend: Cops wasted 30 minutes arguing about jurisdiction Breaking News Jan 6, 2013
    General Outlaw (16 minutes in there is a Lightsaber Fight) Videos Sep 12, 2011
    Sweet ( & POWERFUL ) Simran ! - 3.5 minutes Sikh Sikhi Sikhism Feb 22, 2010
    Nature The Girl Who Silenced The World for 5 Minutes Breaking News Oct 26, 2009

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    =[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
    > 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
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 11 May 2006 15:31:01 -0700, Robert J
    <RobertJ@discussions.microsoft.com> 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).
    >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]
     

Share This Page