Home > Enterprise >  Find the earliest and latest time for each day based on a time range criteria in Google Sheets
Find the earliest and latest time for each day based on a time range criteria in Google Sheets

Time:02-27

I have two columns in Google Sheets:

B | C Date | Time 2/21/2022 | 7:30:02 AM 2/21/2022 | 7:48:02 AM 2/21/2022 | 8:24:05 AM 2/21/2022 | 2:34:02 PM 2/21/2022 | 2:56:02 PM 2/22/2022 | 8:05:00 AM 2/22/2022 | 8:15:00 AM 2/22/2022 | 3:00:02 PM 2/22/2022 | 3:15:02 PM 2/22/2022 | 3:25:14 PM etc...

enter image description here

  • Related