Min and Max time issue

[XLalbania]

Hello excel gurus
Thank you in advance for any of your help
I'm really stuck with this time issue
I need to extracct the earliet time and leatest tme
see the images
Thank you

\1

[Phuocam]

Try:
D3 =MIN(A2:A6)
E3 =MAX(IF(B2:B6>A2:A6,B2:B6,B2:B6+1)), array formula, enter with Ctrl+Shift+Enter.

[zbor]

Use MIN function in both cases.

Abotu attachment we prefere to have attachment in the forum (not external links) and workbook rather than picture.

[XLalbania]

Phuocam wrote:

Try:
D3 =MIN(A2:A6)
E3 =MAX(IF(B2:B6>A2:A6,B2:B6,B2:B6+1)), array formula, enter with Ctrl+Shift+Enter.

Wooowww!! Yess yess yess!! Phuocam
perfect formula, is exactly what i needed, thank you so much you made my day....

Zbor write:

Abotu attachment we prefere to have attachment in the forum (not external links) and workbook rather than picture.

Sorry I didn't know!!
i will do next time...
This forum is great thank yo everybody

[Phuocam]

You're welcome.