Paul,

I'm not sure that this is what you want but if you enter 00:00 in A1, 00:15
in A2, highlight both cells and copy down using the fill handle the column
will be indexed in 15 minute intervals.

However, I for one found it quite confusing not knowing what day the time is
in so I formatted the column Format Cells Custom
dddd d-mmm-yy hh:mm
I enter the date, a space and then the times 00:00 and 00:15 as before in A1
& A2 and copy down. I found (in xl97) that I got a one minute error after
row 100.

I then entered 00:15 in cell B1. In A2 I entered the formula =A1+$B$1 and
copied that down to get the required days, dates & times.
I then copied the range and pasted it back in the same place with Past
Special Values.

HTH

Sandy


"Paul" wrote in message
...
Hi

Anybody able to help? I need to quickly draw up a schedule for the set up
of a large stage
show (over 3 days 24hr working). I need to show time down one column in
15min stages in
24hr clock (Hrs & Mins).

As usual time is of the essence.

Many thanks

Paul