Time planner

P

Paul

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
 
B

bigwheel

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)
 
S

Sandy Mann

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
 
B

b&s

Another way would be:

Format column A:
Format > Cells > Custom > dddd dd-mm-yy hh:mm
In A1 enter:
09-06-05 00:00
Open: Edit > Fill > Series...
in 'Series in' select: Columns
in 'Type' select: Date
in 'Date unit' select: Day
in 'Step value' enter: 00:15
in 'Stop value' enter: 13-06-05 00:00
OK!

hth!
 
Top