In my Excel 2003 it works fine. Makeusre it is really a cell in row 7. do
you have any hidden rows.

The formula is pretty simple. It take the row number and divides by 2. If
it is an odd row it adds 5 minutes, otherwise, it add 15 minutes. I used
timevalue to convert 00:05 and 00:15 to an excel serial time.



8:00
8:15
8:20
8:35
8:40
8:55
9:00
9:15
9:20
9:35
9:40
9:55
10:00
10:15
10:20
10:35
10:40
10:55
11:00
11:15
11:20
11:35
11:40
11:55
12:00
12:15
12:20
12:35


"Josh W" wrote:

Correction! A7 has to be 09:00 (the formula is 15 min+5min+15min+5min etc.

"Josh W" wrote:

I am trying to create a time formula in increments of 15 minutes then 5
minutes then again 15 minutes then 5 minutes etc as follows::
cell A1 08:00
cell A2 08:15
cell A3 08:20
cell A4 08:35
cell A5 08:40
cell A6 08:55
Cell A7 09:10
How do I do this? Thanks, Excel 2003.