| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
On call calendar question
Excel handles dates & times great. Just separate the start & end times into
two different columns so the aggregation will be easier. -- http://HelpExcel.com "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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Very easy question! (But not sure what to call it - maybe transpos | Excel Worksheet Functions | |||
| find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
| Calendar Holiday question | Excel Discussion (Misc queries) | |||
| Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
| Calendar Question | Excel Discussion (Misc queries) | |||
Threaded Mode
