entering the time in each cell

[toddp2]

Hi

Having trouble or have just forgot looking to enter the time in cell B2 e.g. 12.00 then in the next cell 12.30, 1.00, 1.30 but its not doing it the way I thought

Toddp

[zbor]

write in B2 12:00
Then in B3 use formula =B1+0.5/24

0.5 / 24 (half hour step divided by 24 hours... So if you want to change step then change this factor).

[Glenn Kennedy]

...or put 12:00 in B2 and 12:30 in B3. Select both cells and drag down.

[Tony Valko]

Depending on what the OP is going to use this for, both suggestions have/create rounding errors.

B2:Bn = sequence generated by one of the suggestions

Try this...

D2 = 13:00 (manually entered)

E2: =MATCH(D2,B:B,0)

Result: #N/A

And you'll get the same result for many attempted matches.

[Tony Valko]

Try this...

Enter 12:00 AM in B2

Enter this formula in C2:

=ROUND((B2+TIME(0,30,0))*1440,0)/1440

Format as h:mm am/pm then copy across as needed.