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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calendar Question 1
summarizing data from various workbooks 3
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Auto-populate other cells based on dates 2
Calculating interest due on late loan payments 1
Adding absences in rolling twelvemonths in a calendar 5
Date Format 1
Conditional Format based on dates 3

Back
Top