Forum Discussion
Date and Time to Time Range Formulas
Hi expert I would like to know what is formula to group the time range as shown in below table regardless what the date is. Date and Time Time Range 7/31/23 9:29:58 AM 9-10 AM 7/31...
anwarsafian To avoid potentially complex formulas, I would just create a list with the groupings from 0-1 AM to 11 PM-12 AM and use a simple INDEX function to pick-up the correct grouping based on the HOUR of the date/time. See attached.