EXTRACTING MIN AND MAX TIME FROM TIME STRING

[dockery0848]

I need to extract the minimum and maximum times (separately) from a list of times based on one criteria. The list is in military time and I am not getting the max time correct.
this is the formula i am using - =IF(ISERROR(MAXIFS(PLAN!$O:$O,PLAN!$D:$D,'Perf Ind'!L4)),"",MAXIFS(PLAN!$O:$O,PLAN!$D:$D,'Perf Ind'!L4)) - I extracted the start and end times from the string in column E and F but when I put in the formula for max time, it gives me 23:00 because that is the biggest. How can I make this formula pick 4:55?

Op No.	SortProgram	Tour	Run#	Start	End	Fed	MODS	Last Updated	FED	START	END
439000​	439PCITY	1​	47​	5/18/2023 23:00​	5/19/2023 4:55​	28187​	5/18/2023​	5/4/2023 9:05​	28187​	23:00​	4:55​
439000​	439PCITY	3​	48​	5/18/2023 17:00​	5/18/2023 23:00​	28584​	5/18/2023​	5/4/2023 9:05​	28584​	17:00​	23:00​

 

[Fluff]

Yes, but you need to use minifs rather than maxifs.