Type 00:00 in your first cell, 00:15 in the next, 00:30, 00:45 and 01:00.
Then select the block of cells and position the cursor over the bottom
right-hand corner. It'll change to a + cursor. Then drag down for your 24
hours (about 100 cells approx)

"Paul" wrote:

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