I have a spreadsheet where cell values of times range from 00:01 (minute) to over 04:00 (four hours). What I want to do is categorize those times into ranges, i.e., 1 minute or less, 2-5 minutes, 6-10 minutes, 11-20 minutes, etc. and reflect that information on the same line as the remaining information.
Is there a function that will do this for me?
Is there a function that will do this for me?