Forum Discussion

anwarsafian's avatar
anwarsafian
Copper Contributor
Oct 21, 2023

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...
excel
rachel's avatar
rachel
Iron Contributor
Oct 21, 2023

anwarsafian 

 

I attached an example to convert time to time value use MATCH function with "match_type=1" to group it.

 

 

MATCH function with "match_type=1" finds the largest value that is less than or equal to lookup_value.

I find it useful for grouping based on value.

https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a#:~:text=The%20MATCH%20function%20searches%20for,second%20item%20in%20the%20range. 

 

 

 

 

Resources