I have a cell with a formula in it that subtracts two times that are
formatted [hh]:mm:ss. The formula works fine but the answer doesn't seem to
come out in the same format. Is there a way to set a cell so that it is in
the same format as its dependents. The dependents are on a different
worksheet.

If not here is my dilema. I have an unlimited number of columns which hold
race times and current place in the race. The columns go time, place, time,
place etc for as many laps as get done in the race. My trouble is i need the
time cells formatted [hh]:mm:ss and the place cells formatted general. The
only way I can think of formatting every second column as time quickly is to
write a sub along the following lines.

For n =1 to 255 (or however many columns there are) step 2

column (n:n).column.numberformat = [hh]:mm:ss

next n

I realise that isn't quite right but I could work it out if there is not an
easier way. Is there an easier way.

Thanks