Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am working on a sheet that is to track meeting times.
I would like to be able to have someone put the date of the meeting, the start time, end time. Excel will calculate the length. And then there will be seperate columns for each employee. And there is an option for the user to type in that the employee is not at the meeting. I would like to have Excel calulate monthly totals for each employee for each meeting they were at in that month. (Example: Bill was at the Jan 5, Jan 12 meetings that were both 60 minutes, but he was not at the Jan 19 meeting that was also 60. But Jill has been to all 3) I would like to have a spot that will say 120 for January meeting minutes for Bill, and 180 for Jill. If someone needs me to post a rough outline of my chart I can. I posted this question before, but having problems moving it from the help I got to my sheet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
How can I show time spent? | Excel Worksheet Functions | |||
Missing library when running 98 project on 2003 | Excel Discussion (Misc queries) | |||
Funcation to average the Time spent | Excel Worksheet Functions | |||
How do I calculate the hours spent on a project by entering a sta. | Excel Worksheet Functions |