View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ronnie-g ronnie-g is offline
external usenet poster
 
Posts: 5
Default Converting decimal fractions of minutes to seconds

Sorry... Question should have read: How do I convert 5.5 minutes to display
5:30 (5 minues 30 seconds).

"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