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

Excel handles dates & times great. Just separate the start & end times into
two different columns so the aggregation will be easier.
--
http://HelpExcel.com
(E-Mail Removed)



"CJC" wrote:

> 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