# Thread: minutes and seconds (office 97 SR1)

1. ## 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

I am using Office 97 SR1
<img src=/S/blush.gif border=0 alt=blush width=15 height=15>

2. ## 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. ## 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>

4. ## 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.

5. ## 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>

#### Posting Permissions

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