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

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

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

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