LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 121
Default Schedule Worksheet

In cell B2 I want to display a time. In cell D2 I want to display a time
that is always 30 minutes later than the time displayed in cell B2. I want
cell E2 to display a time that is always 30 minutes later than the time
displayed in cell D2. I want cell F2 to display a time that is always 15
minutes later than the time displayed in cell D2, and I want cell H2 to
display a time that is always 12 minutes later than the time displayed in
cell F2.

Each cell represents an activity therefore; B2 = Activity 1, D2 = Activity
2, E2 = Activity 3, F2 = Activity 4, and H2 = Activity 5. I want to link a
bar graph to all the activities so that each activity has a column attached
to it. As a result if I enter 5:30am in cell B2, I can see a column that
indicates what time activity B2 will begin, end, and how many minutes it will
take. I can see a column that indicates what time activity D2 will begin,
end, and how many minutes it will take. I can see a column that indicates
what time activity E2 will begin, end, and how many minutes it will take. I
can see a column that indicates what time activity F2 will begin, end, and
how many minutes it will take, and so on.

Can you help me set up a Worksheet that can perform these functions using
Excel 2003?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Daily schedule to new worksheet Dave76082 Excel Discussion (Misc queries) 3 October 2nd 08 07:42 PM
schedule ganga Excel Discussion (Misc queries) 1 March 20th 08 11:33 AM
Schedule within a worksheet BrendaB Excel Discussion (Misc queries) 1 February 7th 08 05:52 AM
Auto create a schedule based on a worksheet. fyrefox Excel Discussion (Misc queries) 0 September 14th 07 12:24 PM
Create patient schedule based on master therapist schedule PapaBear Excel Discussion (Misc queries) 8 October 12th 05 04:56 AM


All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"