I have a set of data with two columns:
Column A: Group
Column B: Time
Sample data:
Group Time A 9:30 PM A 10:30 PM A 3:25 AM A 1:05 AM B 10:00 PM B 10:30 PM B 2:25 AM B 11:15 PM
The goal is to find the earliest and the latest time by each group. I am having problem using the MIN and MAX functions as the desired result I am looking for consider the time before midnight as "early" and after midnight as "late". The time data set is usually in the time interval between 7:00 PM through 4:00 AM, not sure if this helps.
Desired result:
Earliest Time Latest Time
A 9:30 PM 3:25 AM
B 10:00 PM 2:25 AM
I wonder if anyone has done similar logic with time data before. I appreciate the input in advance. Thank you!
-HL
Bookmarks