I want to create a calendar that could be viewed by month, has time shifts
posted for each case manager, totals time for each individual monthly and by
trimester.

Time slots and schedule are quite varied.

Should I enter date and time span in one cell and "name" it to the adjacent
case manager cell?

How would I a gather the information per person?

Example:
name 1 (A1), 12/1/08 12:15-4:30 (B1)

In a separate table see the time summary of hours by month (for this date it
would be 4.25hr)

PS do you think this would work better in Access???
--
Thanks,
CJC