Hi everybody...

Here's my situation. I work at a lan house, and I need to sum the tota
hours that each person has played.

Each user has a number, but there is a record for each time he ha
played.

For example:
A B C
(number) (name) (played hours)
456 Daniel 01:00:00
456 Daniel 02:00:00
456 Daniel 01:00:00
456 Daniel 04:00:00
456 Daniel 00:30:00
456 Daniel 01:00:00
469 Rachel 02:00:00
469 Rachel 03:30:00
469 Rachel 02:30:00
469 Rachel 02:00:00
469 Rachel 01:00:00

and so on...

so this is what I came up with:


=SUMIF(A:A;"=456";C:C) (for daniel)
=SUMIF(A:A;"=469";C:C) (for rachel)

and so on...


but there are 7 thousand members....

I need to find a way to do this in a batch way...


can anyone help me??

Thanks a lot :cool

--
Message posted from http://www.ExcelForum.com