How about formatting under date as dd/3mm/yyyy hh:mm:ss
enter 1/1/07 00:00:00, then 1/1/07 00:15:00, then drag down?

"Daiv" wrote:

I am putting together a template for our reports and need to have every date
of the year repeat itself 95 times (1 time for every 15 minutes in a day),
thenincrement to the next day. In the end column A should start at 01-jan-07
column B: 0:00:00 and repeat until 01-jan-07, 23:45:00 then start at
02-jan-07, 0:00:00. and so on until 31-dec-07, 23:45:00.

We have the times in column B already in there (from the 2006 template) but
need to convert the 2006 dates to 2007. any ideas? The person who did this
in the past is no longer with the company so I do not know how he managed it.
currently they are just straight values so it will take a long time to
switch every year to 07.

Thank you!
Daiv.