=60*24 (minutes in day)

Steve

On Fri, 29 Dec 2006 15:02:02 -0000, 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





--
Steve (3)