Need to return earliest and latest time based on date criteria

[andyfox1979]

I have 4 columns, i want the first two to return the earliest and latest times from two other columns that have date and time (separately). I need a formula that will look at the data based on the date criteria and return the earliest time for that date and another formula to return the latest time for that date:


Output should look like this above


The data looks like below:



Thanks in advance!

 

[jasonb75]

You could use the MINIFS and MAXIFS functions for that.

=MINIFS(TimeList,DateList,DateOfInterest)

 

[andyfox1979]

very strange, all the output is showing as 12:00 AM

 

[jasonb75]

Check that the dates are all valid. 12:00 AM indicates that no match was found for the specified date.