Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduling Field Staff using Excel (perhaps Networkdays function)
I am a Ph.D. student who has several other students going into the
field throughout the summer and I need to know when and where they are so I do not double book them. What I would like to do is make a Gantt chart for these students by entering the dates of when they go out and come back into the first 12 - 15 colums (i.e. several trips following each other on the same row). Then I would like Excel to format column cells, that represent the days of the months, for those days that the students are away (each student being in a separate row). I have tried to use MS Project but this does not have the capacity to do this. Now I would like to use excel. Not sure if I am clear on this so don't hesitate to ask questions for clarification. If anyone has ventured down this road I would appreciate any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduling Field Staff using Excel (perhaps Networkdays function)
Hi,
See if the following wil help (creating a Gantt chart in Excel) or search web ("Gantt charts in Excel"). http://office.microsoft.com/en-us/as...346051033.aspx If not, can you give an example of your data and how you want the output i.e. Paired Start and End dates? Each column respresenting one day? (Excel imit of 256 columns)? HTH "Toxman" wrote: I am a Ph.D. student who has several other students going into the field throughout the summer and I need to know when and where they are so I do not double book them. What I would like to do is make a Gantt chart for these students by entering the dates of when they go out and come back into the first 12 - 15 colums (i.e. several trips following each other on the same row). Then I would like Excel to format column cells, that represent the days of the months, for those days that the students are away (each student being in a separate row). I have tried to use MS Project but this does not have the capacity to do this. Now I would like to use excel. Not sure if I am clear on this so don't hesitate to ask questions for clarification. If anyone has ventured down this road I would appreciate any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scheduling staff to tasks based on seniority | Excel Discussion (Misc queries) | |||
EXCEL NETWORKDAYS FUNCTION | Excel Discussion (Misc queries) | |||
how does one use the NETWORKDAYS function in a excel VB macro? | Excel Programming | |||
how many staff have 1 skill, how many staff have 2 skills, etc. | Excel Discussion (Misc queries) | |||
MS Excel Function - Networkdays | Excel Worksheet Functions |