List of Names in Column A
Dates in Column B.
Times (hours only) in column C.

How do I count the first instance for each name for the hour only?
(Some names are duplicated and I want a name count in my pivot table)

Assuming real times in col C

In D2, copied down:
=IF(COUNTA(A2,C2)<2,"",IF(SUMPRODUCT((A$2:A2=A2)*(HOUR(C$2:C2)=HOUR(C2)))<2,1,""))

Just sum col D for the result
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"J.W. Aldridge" <(E-Mail Removed)> wrote in message
news:b5f0dfe6-a3de-4d2e-9777-(E-Mail Removed)...
> List of Names in Column A
> Dates in Column B.
> Times (hours only) in column C.
>
> How do I count the first instance for each name for the hour only?
> (Some names are duplicated and I want a name count in my pivot table)

thanx!

welcome, nice of you to feedback here.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"J.W. Aldridge" <(E-Mail Removed)> wrote in message
news:2963edbb-d3d1-4a05-b17e-(E-Mail Removed)...
> thanx!
>