View Single Post
  #4   Report Post  
Lori
 
Posts: n/a
Default How do I convert time (38:30) to decimal (38.5) format?

Thank You!

"Anne Troy" wrote:

In a cell that's formated as number, 2 decimals, put: =B1*24
Where B1 contains your 38:30.
************
Anne Troy
www.OfficeArticles.com

"Lori" wrote in message
...
How do I convert time (38:30) to decimal (38.5) format?