Adding 10 Seconds to the Previous Cell Value

[FormalAbility1]

Hello everyone,This is probably quite a simple request however I am having a lot of trouble with it.I would like to write to a cell the previous cells time value + 10 seconds. I have tried several approaches after a lot of googling, however below is what I started with and what I would like to understand is why this doesn't work - as in my head it is logical.Cells(Row, 1).Value = Cells(Row - 1, 1).Value + (10 / (3600 * 24))The cell data is in the special format DD:MM:YYYY HH:MM:SS - which is a reason this may not work, however if I add + (10 / (3600 * 24)) to the cell manually then it successfully adds on 10 seconds. Thanks

 

[Norie]

You could add TimeSerial(0,0,10).