+ Reply to Thread
Results 1 to 2 of 2

Minutes to seconds

  1. #1
    Registered User
    Join Date
    11-21-2005
    Posts
    6

    Minutes to seconds

    Hi, I'm facing a little problem and I have no idea how to solve this, so I hope some of you guys can help me out on this.

    I'd like to see a time of for instance 6:08.74 (6 minutes, 8 seconds and 74 hundreds) to be calculated as a value of 368.74 seconds.
    So let's say C10 says 6:08.74 then I'd like to have a formula in C11 which tells me that it's the same as 368.74 seconds.

    Hope you guys can help me out,
    thanks is advance

    Partysquad.

  2. #2
    Bob Phillips
    Guest

    Re: Minutes to seconds

    =C10*24*60*60

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Partysquad" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Hi, I'm facing a little problem and I have no idea how to solve this, so
    > I hope some of you guys can help me out on this.
    >
    > I'd like to see a time of for instance 6:08.74 (6 minutes, 8 seconds
    > and 74 hundreds) to be calculated as a value of 368.74 seconds.
    > So let's say C10 says 6:08.74 then I'd like to have a formula in C11
    > which tells me that it's the same as 368.74 seconds.
    >
    > Hope you guys can help me out,
    > thanks is advance
    >
    > Partysquad.
    >
    >
    > --
    > Partysquad
    > ------------------------------------------------------------------------
    > Partysquad's Profile:

    http://www.excelforum.com/member.php...o&userid=28970
    > View this thread: http://www.excelforum.com/showthread...hreadid=487030
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1