My boss handed me a 2000 tab report of data that looks like this:
Wednesday 10/5/2011
12:10 AM Armed 1352 -CA cityname, MBS 2
12:29 AM Disarmed 1352 -CA cityname, MBS 2
2:39 AM Disarmed 1352 -CA cityname, MBS 2
3:40 AM Armed 1352 -CA cityname, MBS 2

All in one cell, the next cell down has a different date. He has given me 1 day to format the data to say:
time in: 12:10 AM
Time out: 12:29 AM
and to subtract time out from time in.

Any suggestions? I need a way to do this quickly.
I have found a time to get rid of all the "Armed 1352 -CA cityname, MBS 2" but not to insert the other information I know the formula to do the math...