Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time differences in a column | Excel Worksheet Functions | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Time Sheets | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |