Decimal minutes to mm:ss format

P

PSRumbagh

I want to convert decimal minutes (e.g. 36.357) into mm:ss format. Does
excel 97 have a built in functin? If not, how do I create one.

Example: 36.357 minutes => 36:21.42
 
P

PSRumbagh

Thanks.

If time is greater than 59.99916667 minutes MUST use format cell as h:mm:ss
after dividing by 1440.
 
T

T. Valko

Try this format:

[m]:s.00

The brackets [ ] will keep the minutes from rolling over after 60.
 
M

Modeste

Bonsour® PSRumbagh avec ferveur ;o))) vous nous disiez :
I want to convert decimal minutes (e.g. 36.357) into mm:ss format.
Does excel 97 have a built in functin? If not, how do I create one.

Example: 36.357 minutes => 36:21.42
Click to expand...

literaly :
36.357 / "0:1"
result format [m]:ss
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compute MPH from Distance and Minutes:Seconds? 1
How can I convert seconds into minutes? (mm:ss -> min.x) 2
decimal time data entry 5
Converting standard time to decimal time 2
Decimal numbers to time format. 5
Excel Convert Datetime Stamp to HH and MM Worked 7
Formating seconds into mm:ss 4
How do I convert time as text 'mm:ss to time value in Excel 5

Top