Thread
:
How do I convert time (38:30) to decimal (38.5) format?
View Single Post
#
2
Anne Troy
Posts: n/a
How do I convert time (38:30) to decimal (38.5) format?
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?
Reply With Quote