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
|