find the min and max of the time of the date

[okl]

Hi there

I have a date column, time column and a column message text with "Access" or "Exit"

i trying to find the :
(1) Earlier time of the Access of that Day of every given date
(2) And in between "Access" and "Exit" , what is the max duration of every given date?
(3) Lastly, the latest "Exit" time of the every given date

attached the data sample.

Thanks

[sktneer]

Please try this...

In J2

Please Login or Register  to view this content.

and copy it down.

In L2

Please Login or Register  to view this content.

and copy it down.

In K2

Please Login or Register  to view this content.

and copy it down.

[okl]

Hi sktneer,

Your K2 doesnt seem right?

No value in N2 and M2...