L
Lori
How do I convert time (38:30) to decimal (38.5) format?
A
Anne Troy
In a cell that's formated as number, 2 decimals, put: =B1*24
Where B1 contains your 38:30.
************
Anne Troy
www.OfficeArticles.com
Where B1 contains your 38:30.
************
Anne Troy
www.OfficeArticles.com
P
Peo Sjoblom
Multiply with 24 AND format as general or number
--
Regards,
Peo Sjoblom
(No private emails please)
--
Regards,
Peo Sjoblom
(No private emails please)
L
Lori
Thank You!
Anne Troy said:
A
