| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I convert time (38:30) to decimal (38.5) format?
How do I convert time (38:30) to decimal (38.5) format?
|
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
How do I convert time (38:30) to decimal (38.5) format?
Multiply with 24 AND format as general or number
-- Regards, Peo Sjoblom (No private emails please) "Lori" wrote in message ... How do I convert time (38:30) to decimal (38.5) format? |
|
#4
|
|||
|
|||
|
How do I convert time (38:30) to decimal (38.5) format?
Thank You!
"Anne Troy" wrote: 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? |
|
#5
|
|||
|
|||
|
How do I convert time (38:30) to decimal (38.5) format?
Welcome! :)
************ Anne Troy www.OfficeArticles.com "Lori" wrote in message ... Thank You! "Anne Troy" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Time Format Auto Entry AM and PM | Excel Discussion (Misc queries) | |||
| Help Q: Entering 7 p time format, does not convert to 19:00 | Excel Discussion (Misc queries) | |||
Linear Mode
