Need to return earliest and latest time based on date criteria

andyfox1979

New Member
Joined
Dec 5, 2012
Messages
32
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:

Post image
Output should look like this above


The data looks like below:

Post image

Thanks in advance!
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
9,579
Office Version
2019
Platform
Windows
You could use the MINIFS and MAXIFS functions for that.

=MINIFS(TimeList,DateList,DateOfInterest)
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
9,579
Office Version
2019
Platform
Windows
Check that the dates are all valid. 12:00 AM indicates that no match was found for the specified date.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,364
Messages
5,468,189
Members
406,570
Latest member
Ktvu2006

This Week's Hot Topics

Top