Text to numbers?

  • Thread starter Thread starter JAlexa5834
  • Start date Start date
J

JAlexa5834

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
 
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.
 
Back
Top