Thread: Min Time on Specific Date
View Single Post
 
Old 02-09-2020, 07:21 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
In E2, either:
=MINIFS($C$2:$C$14,$B$2:$B$14,B2)
which will put the earliest time against all rows, or:
=IF(MINIFS($C$2:$C$14,$B$2:$B$14,B2)=C2,C2,"")
which will only show a time on rows where the time is the minimum for that day.
Reply With Quote