CODEWITHSUNDEEP
excel
Kristenl2784
Kristenl2784

Reputation: 55

Excel - Incrementing

I'm trying to figure out how to increment by 5 seconds.

The format I need to keep is:

0.00:00:00

So, what I'm looking for is:

0.00:00:00
0.00:00:05
0.00:00:10

once it gets to 1 minute it would be

0.00:01:00
0.00:01:05

etc.

I have been able to achieve this but only as format date and time, and I need it to be values but I don't know how to do it.

When I click on a cell it looks like this enter image description here

I have a file where someone at some point was able to make it look like the image below, and this is what I'm looking for: enter image description here

Upvotes: 0

Views: 34

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

In A1 enter:

=TIME(0,0,(ROW()-1)*5)

and copy downwards:

enter image description here

Format as shown above.

Upvotes: 1

Related Questions