automating a report

[arnoldmiranda]

Cell A1 - 8/31/2011 10:06:00 AM>Assigned> 9/2/2011 4:14:45 PM>Pending with CMST> 9/9/2011 9:16:02 PM>Pending with Requestor> 9/11/2011 9:50:13 PM>Pending with CMST> 9/13/2011 6:53:18 PM>Resolved>


Cell A 2 - 8/31/2011 10:15:00 PM>Assigned> 9/8/2011 8:47:46 PM>Pending with CMST> 9/8/2011 8:54:48 PM>Pending with Requestor> 9/9/2011 5:56:14 PM>Pending with CMST>9/9/2011 6:05:23 PM>Resolved>

The data runs up to 100's of rows

Hi,
I have an data dump that looks like this (this entry is captured in a single cell and could have various variations) but the premise is that it's a time stamp dump that captures the events of a ticket from the time it enters a queue to the time it's resolved. What I am struggling with is to transform this data into a report which will calculate the # of hours the ticket has been in various stages. I dont know how to upload an excel file on the forum so I really hope this explains what I am attempting. Currently I so this manually and I know it's not the most efficient way. I hope someone can help me solve this problem

Thanks

 

[Smitty]

You might want to try Data-->Text to Columns with > as the delimiter.

To post a shot of your sheet, follow the link in my sig.

HTH,

 

[arnoldmiranda]

I tried that, however there are some funny characters (a question mark in a box) which prevents me from doing this, the text to column function doestn work