Return First Activity Time Stamp

[xiexie089]

Hi ExcelForum Team--

Here I am once again asking for help. I would like to request assistance in getting first activity time stamp from Timecard Detail table. I would like to get the first Inbound Phone Time and the last OUT Activity code as logout using the employee ID. I tried using MINIFS but it is not working.

I tried this code
=Minifs(J:J,N:N,"Inbound Phone Time",C:C,T7)

Sample Time Card.xlsx

Your help is very much appreciated.

[AliGW]

Where is this in the worksheet?

[xiexie089]

Hi! Sorry, I updated the attachment.

[JeteMc]

I believe that the following will yield the values (times) you expect.
1. Unmerge cells C7:C27 and copy the ID number down by selecting C8:C27, typing =C7 into the active cell and then pressing Ctrl + Enter
2. Unmerge cell P27
3. Select P7:P27 and use the text to column feature (simply open and then press Finish)
4. The formula for Minimum time of the first incoming call is: =MINIFS(P:P,T:T,"Inbound Phone Time",C:C,C7)
5. The formula for the OUT activity time is: =MINIFS(P:P,T:T,"OUT",C:C,C7)
Let us know if you have any questions.