How to make a column with time from 00:00:00 to 23:59:50?

Question

excel

Hello! There is such a task to make a temporary column with an interval of 10 seconds.
You need to get a column like this:
00:00:10
00:00:20
00:00:30
00:00:40
00:00:50
00:01:00
00:01:10
***
23:59:50
Like this can it be done in excel?

Answer 1

Done without problems.

Answer 2

The day is stored as 1.0, so 1 second will be equal to 1/(24*60*60)
As a result, to add 10 seconds, you need to use the formula:

=A1+10/(1440*60)
где A1 - предыдущая ячейка