Getting first "IN" and last "OUT" time in Work

margerome13

New Member
Joined
Jan 18, 2016
Messages
1
Hello Guys,

I hope you could help me. I have table with names and time in and time outs of our employees and the corresponding dates. The excel attachment is the MIS report of the biometrics. I want to get the first "IN" of a particular date, and the last out of a particular date range, and a particular employee name. Is there a formula where I can get only the first in and last out given the said scenario. The table at the right is where I want the answers to fill in with yellow filler.

Here is the link of the Excel File for more details: https://www.dropbox.com/s/nio63iku9xygg0z/Excel Formula Question.xlsx?dl=0
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

oldbrewer

Well-known Member
Joined
Apr 11, 2010
Messages
11,004
inoutinoutinout
fred09:0009:4510:5513:2014:1017:30
the first in is the minimum of F10:K10
the last out is the maximum
09:00
17:30
I never download stuff on here so I have no
idea if this is your requirement…

<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,132,671
Messages
5,654,664
Members
418,147
Latest member
dorkas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top