How to fill 86,400 rows of time from 0:00:00 to 23:59:59

[slinky]

Hello folks,


I would like to fill the time 0:00:00 to 23:59:59 (A1:A84400) without dragging the mouse forever. This is how I try to do it but unsuccessful.


........A

1 0:00:00

2 0:00:01

3


I highlighted A1:A3, clicked 'HOME'> 'FILL' > 'Series'> 'check radio Series in 'Column', Type 'Linear'> Step value 1.1574..........E-05(smartpant Excel figures this out), Stop value = 1.


But Smartpant returned A3 as 0:00:03 without the rest of them....How to do it? Thank you.

 

[fred]

step value should be 0:00:01 and stops at 23:59:59

 

[slinky]

Worked like a charm, thanks fred!


I put redundant info on it, this is all needed.


--------A

1 0:00:00

 

[Hui]

In the name box above A1 type A1:A86400

You'll now have A1:A86400 selected,with A1 as the active cell

Type =time(0,0,row()-1) Ctrl Enter

 

[oldchippy]

@Hui....,


I get an error beyond row 32768 #NUM!, an I doing something wrong?

 

[Hui]

No

That is probably the limit of the number of seconds that time can use!

So much for full 64 bit support

 

[uday5]

Please define first two cells

A1 0:00:00

A2 0:00:01


And use the formula "=A2+$A$2" in Cell A3 so that it will reflect as below.


A3 0:00:02


Type in name box "A3:A86400" and do 'Cnrl+D'


So that it will fill to 23:59:59 with out any error.