| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert imported data with . separator for decimal into , separato | Excel Discussion (Misc queries) | |||
| Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions | |||
Linear Mode
