Populate First Time Stamp For Staff

[kumara_faith]

Hi,

I have the following time and date stamp for my staffs from the attendance system which captures every time the staffs enter or exit the office:

<!-- Please do not remove this header -->
<!-- Table easily created from Excel with ASAP Utilities (https://www.asap-utilities.com) -->
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellpadding="0">
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><u><b>Date</b></u></font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><u><b>Time</b></u></font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"><u><b>Staff Name</b></u></font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-01</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">14:01:39</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Joanne</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-01</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">18:37:10</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Joanne</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">7:22:52</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Michelle</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">7:24:34</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Michelle</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">7:25:13</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Michelle</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:05:27</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Michelle</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:07:21</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Michelle</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:08:15</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Michelle</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:16:03</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Natallie</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:20:24</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Natallie</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:25:46</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Batrice</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:30:30</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Katherine</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:45:30</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Katherine</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:55:30</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Katherine</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:30:45</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Batrice</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:31:31</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Batrice</font></td></tr>
</table>
I need to summarize a report to capture what time they came to the office, which should be the first entry time and date for every single day. The end result should like this:

<!-- Please do not remove this header -->
<!-- Table easily created from Excel with ASAP Utilities (https://www.asap-utilities.com) -->
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellpadding="0">
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Date</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Joanne</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Michelle</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Natalie</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Batrice</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Katherine</font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-01</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">14:01:39</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td></tr>
<tr><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2019-01-02</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">7:22:52</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:16:03</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:25:46</font></td><td bgcolor="#FFFFFF" align="left" valign="top" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8:30:30</font></td></tr>
</table>

I tried with the following formula but it did not work. Appreciate any help:

=SUMPRODUCT((C2:C17=F2)*(A2:A17=E3),MIN(B2:B17))

 

[DanteAmor]

Try:

<b></b><br /><br /><table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#92d050; font-weight:bold; text-align:center; ">Date</td><td style="background-color:#92d050; font-weight:bold; text-align:center; ">Joanne</td><td style="background-color:#92d050; font-weight:bold; text-align:center; ">Michelle</td><td style="background-color:#92d050; font-weight:bold; text-align:center; ">Natallie</td><td style="background-color:#92d050; font-weight:bold; text-align:center; ">Batrice</td><td style="background-color:#92d050; font-weight:bold; text-align:center; ">Katherine</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">01/01/2019</td><td style="text-align:right; ">14:01:39</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">02/01/2019</td><td > </td><td style="text-align:right; ">07:22:52</td><td style="text-align:right; ">08:16:03</td><td style="text-align:right; ">08:25:46</td><td style="text-align:right; ">08:30:30</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Array Formula</td></tr><tr><td >F2</td><td >{=MIN((IF($A$2:$A$17=$E2,IF($C$2:$C$17=F$1,$B$2:$B$17))))}</td></tr></table></td></tr></table> <br /><br />

Array formulas
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

 

[kumara_faith]

Hi,

Thank you and appreciate your time. It worked and appreciate your patience.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.