On call calendar question

  • Thread starter Thread starter CJC
  • Start date Start date
C

CJC

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???
 
Excel handles dates & times great. Just separate the start & end times into
two different columns so the aggregation will be easier.
 
Back
Top