|
|
How do I convert time (38:30) to decimal (38.5) format?
Welcome! :)
************
Anne Troy
www.OfficeArticles.com
"Lori" wrote in message
...
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?
|