Decimal minutes to mm:ss format

  • Thread starter Thread starter PSRumbagh
  • Start date Start date
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
 
Thanks.

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

[m]:s.00

The brackets [ ] will keep the minutes from rolling over after 60.
 
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
 
Back
Top