Deleting infromation from part of a cell

[Robert]

Hi all,

I have a small query. I have two columns of 235 items, in
each row in each column each item consists of a date and
time e.g.

22 July 2003 14:15:25

I need to delete the date from each cell in the columns
and keep the time in each cell but I would like to do this
as a group (once off) and not delete from each individual
cell as this will take too much time.

My aim is to subtract the two columns from each other to
get the time taken.

Help ??

Robert
South Africa

 

[Anon]

Hi all,

I have a small query. I have two columns of 235 items, in
each row in each column each item consists of a date and
time e.g.

22 July 2003 14:15:25

I need to delete the date from each cell in the columns
and keep the time in each cell but I would like to do this
as a group (once off) and not delete from each individual
cell as this will take too much time.

My aim is to subtract the two columns from each other to
get the time taken.

Presumably, then, the date in both columns would be the same for each pair
of cells? If so, you don't need to remove the date - just subtract one from
the other.