I wish to create in column in an Exel spreadsheet which has times of day at 30 minute intervals.

I've put the time 8:00am into the first cell (cell A1) and formatted it in the way I want.

What is the formula I need to put in the cell A2 in order to get the result 8:30am?

It's annoying me!

Thanks!

I'm pretty sure if you go to help in Excel it lists all the formulae. It might be something like dateadd or adddate?

Try this:

=A1+TIME(0,30,0)

(not sure if it's the neatest way to do it, but it seems to work)

Thanks Rich!

quick way is write 8.30am in next cell, then if you highlight the 8.00am and 8.30 boxes, it should have a black box around it, hopefully when you click on teeny little arrow at bottom right of it , and drag it across the cells yo uneed to fill, it should work!

works with dates and numbers anyway! :)

Even better! - thanks!

All good solutions.

If you add 1 to a time, the '1' represents 1 day. Therefore to add 1/2 hr you add 1/48 to the time.
(24 hrs in a day -> 48 half hours in a day).