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