Help! Workinghours displayed in a chart, impossible??
Posted by ESPEN on January 08, 2001 11:31 PM
How can I show when a employee has his workingperiod, in a 24 hours chart?
Posted by M:force on January 09, 2001 1:48 AM
Please give us some more clues about what you are trying to do.
Posted by espen on January 09, 2001 6:06 AM
At my job we would like to see on a "ganttchart" who is working when. I'm on an airport, and we need to easily see who's at work at which arrivels/departures.
But when I have "series 1" whith info. about WHEN employee starts to work, ex 15:00, it is displayed from 00:00 to 15:00. And then when "series 2" is containig info about HOW LONG the employee work, ex 07:00 hrs, it seems like the computer makes it 31 hrs. 24 hrs more than I've written.
If only knew how to make series 2 correct, I know how to make series 1 invisible.
Do you know if there are any examples of this type of chart?
I hope that you can help me out with this one, because I haven't found this question in the archive.
Posted by Aladin Akyurek on January 09, 2001 6:40 AM
This might help:
Posted by espen on January 09, 2001 2:42 PM
Hi Aladin Akyurek
I've checked out the lacher site, and printed out the macro. But I've never used macro, and I don't understand the logic that there propably are in this code. And the example was for three "employees", but I have somewhere between 12-18.
Is it not possible to make this less complicated?
Posted by espen on January 09, 2001 3:04 PM
I checked out Lachers site, but those macro code thing was to heavey, I've never been into those things. Is there a simple way to do it, or how can I learn about macros. I need a gnattchart for 12-18 employees.
Posted by Aladin Akyurek on January 09, 2001 3:18 PM
I'm sorry, Espen, I can't help you on this. I just passed the Lacher example to you, as a start point, say.
Posted by espen on January 09, 2001 5:28 PM
do you know of any sites where to learn how the macrocode system works? It seems just like a lot of words whithout any "red line" to catch up with.
Posted by Tim Francis-Wright on January 10, 2001 1:28 PM
There's a simple Gantt chart at
You'll want to do the following:
1. Reformat the dates in the worksheet and
the chart x-axis to be times
2. Change the formula in the duration column
so it's (end time) - (beginning time), not
(end date) - (beginning date) + 1
3. Redefine the x-axis minimum, maximum,and
4. Change the source data as you need
(right-click on the chart to change the source
This doesn't require any macros, unless you
want to do something extra fancy.