Finding earliest login and latest logout time for a date

[amohamedfarook]

hello,

I need to find earliest login and logout time for a particular date....

any help would be highly appreciated...

sample image.jpg

[AliGW]

Welcome! Instead of an image, attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Glenn Kennedy]

Try these array formulae:
Earliest: =MAX(IF(B2:B20=F1,C2:C20))
Latest: =MAX(IF(B2:B20=F1,D2:D20))

Adjust the ranges as needed.

Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...