ronnie-g, SteveW has given you the answer about 1440, it is the number of
minutes in a day. I agree his solution is simpler. I was thrown a bit by
your original 5.5 = 5min 12sec and thought you were representing 1/5 of a
minute (12 seconds in the decimal portion. That's why I worked it with text
vs time. I completely agree that Richard's solution is a better one since
you are looking for a time conversion that works "normally".

"ronnie-g" wrote:

Richard I am curious where did you come up with the 1440? By the way this
works and is much easier than the other responses. Thanks.

"RichardSchollar" wrote:

Hi Ron

How do you get 12 secs from 0.5 of a minute?

If you have a decimal value eg in A1 of 5.5 and this number represents
your minutes, then you could use a formula like:

=A1/1440

and format the cell as mm:ss to get the format as eg 05:30 (use
hh:mm:ss or maybe [h]:mm:ss if you will have numbers of more than 60
minutes).

Does this help?

Richard


ronnie-g wrote:

How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds).
Thanks!
--Ron