Sorting times by time ranges

[jwpickett]

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?

 

[DonkeyOte]

Perhaps create a lookup table of lower time boundaries in one column and associated "string" in adjacent column - then conduct a lookup based on the time value against that table to return the appropriate value, eg:

Excel Workbook
	A	B	C	D	E	F
2	00:30	20 minutes or more			00:00	1 minute or less
3	00:06	6-10 minutes			00:02	2-5 minutes
4	00:03	2-5 minutes			00:06	6-10 minutes
5	00:14	11-20 minutes			00:11	11-20 minutes
6	00:17	11-20 minutes			00:20	20 minutes or more
7	00:01	1 minute or less
Sheet5

(above assumes whole minute time values of course)