Excel: Every first time of the day


Have been puzzling about the below quite a while. Hope someone can help me out on this. Column A contains days, multiple rows per day Column B contains hours, multiple rows per day I'd like to select/filter the 'earliest' hour (first entry) of each day. How to filter those? Example below. -day time

08-12-2016 09:21:06
08-12-2016 09:20:49
08-12-2016 05:10:06
07-12-2016 16:47:42
07-12-2016 16:44:40
07-12-2016 16:44:25
07-12-2016 08:15:55
07-12-2016 08:15:55
07-12-2016 08:15:55
07-12-2016 08:15:55
07-12-2016 05:08:23
06-12-2016 16:46:59
06-12-2016 16:41:04
06-12-2016 16:40:48
06-12-2016 04:20:05
05-12-2016 17:14:36
-etc- Thanks. =


This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of March 15, 2017.


For more resources for Microsoft Excel