Hi

I have a system log that captures the start & end time of each process.
Based on the combination of different log description, I have narrowed it
down to the follwing events: CALC-START, CALC-END,
CBVIEW-START,CBVIEW-END,ALLOC-START, ALLOC-END, OLAP-START, OLAP-END

Note: these events will not be in any specific order. Since they run on
different threads, depending on the volum of data, they may complete in any
order.
Also, we may have a CALC-START and another CALC-START without the CALC-END,
because of some issues the job was manually cancells.

The ask:
Is there a way to re-organize the data and out the start time and end time
in different columns so the duration can be caclucated for each event.?

Time Event
10/09/2009 22:28:05 ALLOC-END
10/09/2009 22:03:28 ALLOC-START
10/09/2009 22:02:29 CBVIEW-START
10/09/2009 22:02:07 CALC-END
10/09/2009 19:42:40 CALC-START
10/06/2009 1:23:26 OLAP-END
10/06/2009 0:49:59 CBVIEW-END
10/06/2009 0:44:23 OLAP-START
10/06/2009 0:44:22 ALLOC-END
10/05/2009 23:49:38 ALLOC-START
10/05/2009 23:48:10 CBVIEW-START
10/05/2009 23:48:01 CALC-END
10/05/2009 21:51:23 CALC-START