Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    minutes and seconds (office 97 SR1)

    I Have a calculator that converts decimal minutes and seconds to actual minutes and seconds for example

    Total mm / feed speed mm per min

    i.e. 7000mm / 6000 mm per min = 1.166666 which is actually 1minute and 10 secs

    I would like to be able to do this in excel and finish with the result 1 minute and 10 secs and not 1.166666
    Can anyone help please Braddy 60

    I am using Office 97 SR1
    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    If you are a fool at forty, you will always be a fool

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: minutes and seconds (office 97 SR1)

    One way of doing this is to format the cell as time: format/cells/time and choose the third otion down (on my setup) that looks like 13:30:55, or choose a custom format along the lines of h:mm:ss; BUT you will need to convert this to minutes by dividing 1.16 by 1440 (24 hours times 60 minutes).

    HTH

    Brooke

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: minutes and seconds (office 97 SR1)

    Thanks very much Brooke it works perfectly <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    If you are a fool at forty, you will always be a fool

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: minutes and seconds (office 97 SR1)

    One other thing that you want to consider. If you want to show this time as elapsed minutes, then use a custom format of [m]:ss with the brackets aroung the m, or if you want elapsed hours and minutes use [h]:mm:ss. Otherwise, you will get a maximum of 60 miniutes or 24 hours.
    Legare Coleman

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: minutes and seconds (office 97 SR1)

    Once again thanks for your help <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    If you are a fool at forty, you will always be a fool

Posting Permissions

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