convert "37:30:55" to decimal
I have a field that is formated as time format 37:30:55. I would like to
conver this value to decimal value. for example: 113:30:00, I would like to read it as 113.5. How do I do that? Thanks, Sam |
convert "37:30:55" to decimal
Multiply with 24 and format as general or number not time
-- Regards, Peo Sjoblom "Teaman" wrote in message ... I have a field that is formated as time format 37:30:55. I would like to conver this value to decimal value. for example: 113:30:00, I would like to read it as 113.5. How do I do that? Thanks, Sam |
convert "37:30:55" to decimal
Try multiplying by 24 and formatting the result as General.
=a1*24 If A1 contained 113:30:00. Teaman wrote: I have a field that is formated as time format 37:30:55. I would like to conver this value to decimal value. for example: 113:30:00, I would like to read it as 113.5. How do I do that? Thanks, Sam -- Dave Peterson |
All times are GMT +1. The time now is 09:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com