View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JAlexa5834 JAlexa5834 is offline
external usenet poster
 
Posts: 2
Default 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