G
Gadgetman
I need some help with a work schedule done in Excel.
The schedule is not very complex; however, when multiple changes to the
schedule are made for vacations ect, it becomes a garbled mess & I find
that some problems arise for me to be able to mentally determine how
many people are working during a given time when it's in text format. I
think it would be much easier to see in a chart if I was able to convert
the text into one. (A page of our current schedule can be downloaded for
reference at
http://homepage.mac.com/WebObjects/FileSharing.woa/wa/schedule.jpg.jpg-bi
nhex.hqx?a=downloadFile&user=gadgetman&path=.Pictures/schedule.jpg)
If there's a way to do it, I'd like to be able to chart a 24hr period
(6am one day to 6am the next day for example) and be able to see who's
working during that day with the start of the bars of the chart showing
the start time of the person's shift and the end of the bars of the
chart showing the stop time of the shift. I don't know if that makes
sense. I've tried to give an example of what I mean here:
http://homepage.mac.com/WebObjects/FileSharing.woa/wa/24hr_Chart.jpg.jpg-
binhex.hqx?a=downloadFile&user=gadgetman&path=.Pictures/24hr%20Chart.jpg
Any and all help would be appreciated! Thanks!
PS: if the above links for the sample files dont work, the sample files
can be seen/downloaded here:
http://homepage.mac.com/gadgetman/Schedule/FileSharing9.html
The schedule is not very complex; however, when multiple changes to the
schedule are made for vacations ect, it becomes a garbled mess & I find
that some problems arise for me to be able to mentally determine how
many people are working during a given time when it's in text format. I
think it would be much easier to see in a chart if I was able to convert
the text into one. (A page of our current schedule can be downloaded for
reference at
http://homepage.mac.com/WebObjects/FileSharing.woa/wa/schedule.jpg.jpg-bi
nhex.hqx?a=downloadFile&user=gadgetman&path=.Pictures/schedule.jpg)
If there's a way to do it, I'd like to be able to chart a 24hr period
(6am one day to 6am the next day for example) and be able to see who's
working during that day with the start of the bars of the chart showing
the start time of the person's shift and the end of the bars of the
chart showing the stop time of the shift. I don't know if that makes
sense. I've tried to give an example of what I mean here:
http://homepage.mac.com/WebObjects/FileSharing.woa/wa/24hr_Chart.jpg.jpg-
binhex.hqx?a=downloadFile&user=gadgetman&path=.Pictures/24hr%20Chart.jpg
Any and all help would be appreciated! Thanks!
PS: if the above links for the sample files dont work, the sample files
can be seen/downloaded here:
http://homepage.mac.com/gadgetman/Schedule/FileSharing9.html