Deleting infromation from part of a cell

  • Thread starter Thread starter Robert
  • Start date Start date
R

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
 
Robert said:
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.
Click to expand...

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.
 
Back
Top