Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to numbers?
Hello All! I'm working with an application that tracks how long someone takes
to complete a function. The report from said application can export the needed report to an Excel file. However, the timeframe is captured in one cell and presented like this: 5 Hrs 5 Min. How could one go about breaking this down into seperate cells so one could perform calculations on it? Thanks for any ideas! Jim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to numbers?
Hi,
Highlitht the column,data, Text to columns "JAlexa5834" wrote: Hello All! I'm working with an application that tracks how long someone takes to complete a function. The report from said application can export the needed report to an Excel file. However, the timeframe is captured in one cell and presented like this: 5 Hrs 5 Min. How could one go about breaking this down into seperate cells so one could perform calculations on it? Thanks for any ideas! Jim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to numbers?
I'd try this (save first--just in case it doesn't work).
Select the range to fix Edit|replace what: __min (two spaces, then min) with: (leave blank) replace all Then with the range still selected edit replace what: _hrs__ (space, hrs, two spaces) with: : (colon) replace all Then check the range to see if it worked. JAlexa5834 wrote: Hello All! I'm working with an application that tracks how long someone takes to complete a function. The report from said application can export the needed report to an Excel file. However, the timeframe is captured in one cell and presented like this: 5 Hrs 5 Min. How could one go about breaking this down into seperate cells so one could perform calculations on it? Thanks for any ideas! Jim -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to numbers?
Thanks! Worked great!
"Eduardo" wrote: Hi, Highlitht the column,data, Text to columns "JAlexa5834" wrote: Hello All! I'm working with an application that tracks how long someone takes to complete a function. The report from said application can export the needed report to an Excel file. However, the timeframe is captured in one cell and presented like this: 5 Hrs 5 Min. How could one go about breaking this down into seperate cells so one could perform calculations on it? Thanks for any ideas! Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing A Column Of Text numbers To True Numbers: How ? | New Users to Excel | |||
how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) |