Group time in ranges

I am not sure if I put the best title of this thread, but what i need is, I have huge list of time which i want to put in some group like between 0-1 hrs, 2-4 hrs etc.

Lets say I have data in COl A and in Col B i want to label the to the group it should below. Right now i m doing it manually using filters, just want to see of there is any formula I can use.

Below are the groups I need.. And i m attaching a sample data for better understanding.

Less then 1 hour
1 -2 Hours
2 -4 Hours
4 - 6 Hours
6 - 12 Hours
12 - 18 Hours
18 - 24 Hours
24 - 36 Hours
36 - 72 Hours
72 - 168 Hours
> 168 Hours

Hi, amitmodi_mrt!

I suggest this steps:

1. Create an adittional column with the limit upper bound of ranges. If you want a formula, you can use:
[M2] : =IFERROR(--LEFT(SUBSTITUTE(SUBSTITUTE(N2,"> ",""),"-"," "),3),)

2. Create a formula that obtain the resultant text:
[B2] : =LOOKUP(A2*24,M$2:N$12)

Check file with this option developed. Blessings!

Thank You John.. It worked perfect.