+ Reply to Thread
Results 1 to 6 of 6

how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43

  1. #1
    vele Phant
    Guest

    how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43

    how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43 (68 minutes
    and 43 seconds)

  2. #2
    Tushar Mehta
    Guest

    Re: how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43

    In article <[email protected]>, "=?
    Utf-8?B?dmVsZSBQaGFudA==?=" <vele [email protected]>
    says...
    > how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43 (68 minutes
    > and 43 seconds)
    >

    =MINUTE(C31)+SECOND(C31)/100 where C31 contains the time in hh:mm:ss.

    Note that XL may format the cell containing the formula with a time
    format. If so, change it to 'General'.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

  3. #3
    vele Phant
    Guest

    Re: how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.

    Thank you , however i have following example, can you please explain how to
    convert it into Minutes:

    1:02
    5:55
    0:13
    0:21
    51:37:00
    1:15
    0:00
    4:29
    0:59
    15:42
    0:05
    1:33
    0:05
    0:04
    4:48

    Vele Phant

    "Tushar Mehta" wrote:

    > In article <[email protected]>, "=?
    > Utf-8?B?dmVsZSBQaGFudA==?=" <vele [email protected]>
    > says...
    > > how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43 (68 minutes
    > > and 43 seconds)
    > >

    > =MINUTE(C31)+SECOND(C31)/100 where C31 contains the time in hh:mm:ss.
    >
    > Note that XL may format the cell containing the formula with a time
    > format. If so, change it to 'General'.
    >
    > --
    > Regards,
    >
    > Tushar Mehta
    > www.tushar-mehta.com
    > Excel, PowerPoint, and VBA add-ins, tutorials
    > Custom MS Office productivity solutions
    >


  4. #4
    Tushar Mehta
    Guest

    Re: how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.

    I don't know that those numbers mean. Is it information in hh:mm or
    mm:ss? In any case, you already have the building blocks with my last
    post. The functions MINUTE() and SECOND() and you can guess by
    extension that there is a function HOUR(). Just put the pieces
    together depending on what numbers you have.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>,
    [email protected] says...
    > Thank you , however i have following example, can you please explain how to
    > convert it into Minutes:
    >
    > 1:02
    > 5:55
    > 0:13
    > 0:21
    > 51:37:00
    > 1:15
    > 0:00
    > 4:29
    > 0:59
    > 15:42
    > 0:05
    > 1:33
    > 0:05
    > 0:04
    > 4:48
    >
    > Vele Phant
    >
    > "Tushar Mehta" wrote:
    >
    > > In article <[email protected]>, "=?
    > > Utf-8?B?dmVsZSBQaGFudA==?=" <vele [email protected]>
    > > says...
    > > > how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43 (68 minutes
    > > > and 43 seconds)
    > > >

    > > =MINUTE(C31)+SECOND(C31)/100 where C31 contains the time in hh:mm:ss.
    > >
    > > Note that XL may format the cell containing the formula with a time
    > > format. If so, change it to 'General'.
    > >
    > > --
    > > Regards,
    > >
    > > Tushar Mehta
    > > www.tushar-mehta.com
    > > Excel, PowerPoint, and VBA add-ins, tutorials
    > > Custom MS Office productivity solutions
    > >

    >


  5. #5
    JethroUK©
    Guest

    Re: how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.

    why might you want to replace a colon ':' with a '.' dot?

    i think there's more of this you haven't yet mentioned


    "vele Phant" <[email protected]> wrote in message
    news:[email protected]...
    > Thank you , however i have following example, can you please explain how

    to
    > convert it into Minutes:
    >
    > 1:02
    > 5:55
    > 0:13
    > 0:21
    > 51:37:00
    > 1:15
    > 0:00
    > 4:29
    > 0:59
    > 15:42
    > 0:05
    > 1:33
    > 0:05
    > 0:04
    > 4:48
    >
    > Vele Phant
    >
    > "Tushar Mehta" wrote:
    >
    > > In article <[email protected]>, "=?
    > > Utf-8?B?dmVsZSBQaGFudA==?=" <vele [email protected]>
    > > says...
    > > > how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43 (68

    minutes
    > > > and 43 seconds)
    > > >

    > > =MINUTE(C31)+SECOND(C31)/100 where C31 contains the time in hh:mm:ss.
    > >
    > > Note that XL may format the cell containing the formula with a time
    > > format. If so, change it to 'General'.
    > >
    > > --
    > > Regards,
    > >
    > > Tushar Mehta
    > > www.tushar-mehta.com
    > > Excel, PowerPoint, and VBA add-ins, tutorials
    > > Custom MS Office productivity solutions
    > >




  6. #6
    JethroUK©
    Guest

    Re: how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.

    it looks to me like you have hours & minutes, and you want these converted
    to minutes/seconds - if so just divide them by 60


    "JethroUK©" <[email protected]> wrote in message
    news:[email protected]...
    > why might you want to replace a colon ':' with a '.' dot?
    >
    > i think there's more of this you haven't yet mentioned
    >
    >
    > "vele Phant" <[email protected]> wrote in message
    > news:[email protected]...
    > > Thank you , however i have following example, can you please explain how

    > to
    > > convert it into Minutes:
    > >
    > > 1:02
    > > 5:55
    > > 0:13
    > > 0:21
    > > 51:37:00
    > > 1:15
    > > 0:00
    > > 4:29
    > > 0:59
    > > 15:42
    > > 0:05
    > > 1:33
    > > 0:05
    > > 0:04
    > > 4:48
    > >
    > > Vele Phant
    > >
    > > "Tushar Mehta" wrote:
    > >
    > > > In article <[email protected]>, "=?
    > > > Utf-8?B?dmVsZSBQaGFudA==?=" <vele [email protected]>
    > > > says...
    > > > > how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43 (68

    > minutes
    > > > > and 43 seconds)
    > > > >
    > > > =MINUTE(C31)+SECOND(C31)/100 where C31 contains the time in hh:mm:ss.
    > > >
    > > > Note that XL may format the cell containing the formula with a time
    > > > format. If so, change it to 'General'.
    > > >
    > > > --
    > > > Regards,
    > > >
    > > > Tushar Mehta
    > > > www.tushar-mehta.com
    > > > Excel, PowerPoint, and VBA add-ins, tutorials
    > > > Custom MS Office productivity solutions
    > > >

    >
    >




+ 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