Time planner
 

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

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

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

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!

--
regards/pozdrav!
Berislav

In ,
Sandy Mann typed:
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