Extract parts of cells to new columns
 

Hi, hope you all can help me. I am stumped. I have a spreadsheet with info in Column A that is directly dumped from another program. I need total time for each person in another column but with name only and time in another column. You will notice in column A, the red info has the word "Total for" then a number. That is the line I am looking for since each person could have multiple lines for another date. I highlighted in red font the info I need in column A. Column D is how I need the data displayed, this is info I added myself so you can see how I need the data.

Can you please help? THANK YOU!!

Extract parts of cells to new columns
 

Hi,

Am Thu, 19 Mar 2015 18:22:20 +0000 schrieb shani1975:

+-------------------------------------------------------------------+
|Filename: ExcelHELP.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1008|
+-------------------------------------------------------------------+

look he
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "ExcelHELP_New"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional