What would I do:
I would have a table of meetings. Meeting ID (e.g. 1, 2, 3), Date,
Duration. Say I have these in a spreadsheet called Meetings in columns
A:C.
I would have a table of attendances. Just two columns: Meeting ID,
Person. Say I have these in a spreadsheet called Attendances in
columns A:B.
Meeting Person
1 Bill
1 Jill
2 Bill
2 Jill
3 Jill

In Attendances!C2 I can bring the Date with VLOOKUP:
=VLOOKUP(A2,Meetings!A:C,2,FALSE)

In Attendances!D2 I can bring the Duration with VLOOKUP:
=VLOOKUP(A2,Meetings!A:C,3,FALSE)

Now, to get Bill's total minutes during, say, January 2007 (and
assuming your Attendances table has data in A2:B20:

=SUMPRODUCT(D2:D20*(TEXT(C2:C20,"Mmmm YYYY")="January
2007")*(B2:B20="Bill"))

HTH
Kostis Vezerides

On Mar 8, 12:32 pm, Chart_Maker_Wonderer
wrote:
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.