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