Calculating Average Start Time by Employee

[fgruhlke]

I have a list of tickets closed that includes among other things, the date and time the ticket was closed and the employee name. My end goal is to return the average start time (first ticket for the day) for each of the employees found in the particular data set, usually a months worth of data. Can you point me to either a formula or some VBA code that would work? THAT would be great!

[Bo_Ry]

E3:E4 => employee name

F3:F4
=AVERAGE(IF($B$2:$B$24=E3,IF(INT($A$2:$A$24)<>INT(N(+$A$1:$A$23)),MOD($A$2:$A$24,1))))

Ctrl+Shift+Enter

[JohnTopley]

Helper in Column C

=IF(SUMPRODUCT(--(INT($A$2:A2)=INT(A2)))=1,MOD(A2,1),"")

in Column D

=IF(COUNTIF($B$2:B2,B2)=1,AVERAGEIF($B$2:$B$24,B2,$C$2:$C$24),"")

or

=IF(COUNTIF($B$2:B3,B3)=1,$B3 &" " &TEXT(AVERAGEIF($B$2:$B$24,B3,$C$2:$C$24),"hh:mm:ss"),"")