How to compose a Leave Table in text & color bar?

[feliling]

Just wonder if I can use excel to compose a table similarly like this:

A. Upper portion of the table indicated in text: e.g.
Month Name of staff Leave from To
________________________________________________
March ABC 1/3/05 AM 1/3/05 PM
ABC 7/3/05 PM 8/3/05 AM
DEF 3/3/05 AM 15/3/05 PM
GHI 17/3/05 AM 19/03/05PM

B. Lower portion indicated in calendar, with automatically shaded color in
the 'AM' & 'PM' areas: e.g.

Feb 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
16 17 18 19...
______________________________________________________________________

ABC AM AM
PM PM
______________________________________________________________________
DEF AMAMAMAMAMAMAM AM AM AM AM AM AM
PM PM PMPMPMPM PM PM PM PM PM PM PM
______________________________________________________________________
GHI
AM AM AM

PM PM PM
_____________________________________________________________________

I am now using Excel 2002 in Office and Excel 203 at home. So both version
will do.
Many thanks.

 

[Tom Ogilvy]

What is it supposed to use as a datasource to build the two tables?

Why would the March dates be shaded in February?

Would the table only include 1 month.

 

[feliling]

Sorry for the typo mistake. The lower portion responds to the upper part and
should be in 'March' instead of 'Feb'.

Actually this Leave Table is a summary of all leaves projected by my bosses.
Some of them opined it difficult to learn how many of them take the same days
simultaneously within a certain period of time from the 'text nature'. They
prefer to have the color bar chart so that they can know the answer quickly
when they see the 'overlapped' dates. I have difficulties of defining the
fields as 'AM' and 'PM' together with the 'date number' because, e.g. if my
boss is going to take the leave from 2nd Mar pm to 18th Mar am, I used the
'conditional format' to shade the range but it only turned out to shade the
cells namely 18pm to 2am. (because the 'numeric fields' count '1' prior to
'2').

Or can you suggest a better presentation way?
Many thanks.

 

[Toppers]

Hi,
I have some basic code which I can send to you; mail me at
(e-mail address removed) if you are interested.

 

[Tom Ogilvy]

Perhaps this will give you some ideas:

http://groups.google.co.uk/group/mi..._frm/thread/16324d5a84947721/4a7ea2482b1c9ec4

It isn't exactly what you want, but might be a start.