Thread: Formula minutes and seconds
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
  
Posts: 347
Default Formula minutes and seconds
Hi,

Try

=A1*60*24

Regards!
Jean-Guy

"John" wrote:

How do I change the following:
The cell reads: 14:42:0 for minutes and seconds.
I need to convert cell to 14.7
--
John
Reply With QuoteReply With Quote