increment every Nth row by more than 1

[rnomis]

I have been asked to create time slots by 2 second intervals every 10th row. I managed to make changes from a date formula but it only increments by 1 second. I have tried editing the formula but still get 1 second increments instead of 2. I am using the formula:

=TIME(HOUR($C1),MINUTE($C$1),SECOND($C$1)+INT((ROW()-1)/11)) where C1 is the start time.

Any answers very much appreciated.

Thanks in advance

[Fluff13]

How about
=TIME(HOUR($C11),MINUTE($C$1),SECOND($C$1)+INT((ROW()-1)/11)*2)

[rnomis]

Thanks. I ended up with something almost identical. I didn't use brackets for the final *2 and used an absolute reference for the first part. Is your suggestion safer?

=TIME(HOUR($C$1),MINUTE($C$1),SECOND($C$1)+INT((ROW()-1)/11))*2

[Fluff13]

You're formula will multiply the time by 2, not the number of seconds.