All the formulas worked. Only, when I get to 13:00 the format suddenly turns
into 0:15
0:05
0:15
0:05
and so on. How do I overcome this? I want the formula for 24 hours a day.
Thanks.
"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.