Min and max problem in data that has subset

[pabloponza]

Dear everyone

I have problem with min and max
I have these set of ctr which one ctr consist of many do no.
What i want is to find a way or formula that can return min check in time and max check out time of every ctr
Can anyone helps me with this?

Thank you in advance!

best regards,
pablo

ctr time problem.xlsx

[sunil.excel]

Try this.......

[pabloponza]

Thank you sunil! your formula works perfectly well
Thanks again for fast reply

:D