Calculate band on Hours/Time passed

[farhan11941234]

Please help me out to figure out a formula to calculate Date/Time Base Bins (See attached Image).Whenever The ID Creation(Column A) on Current Day and Time 3:00 PM to 6:00 PM, In Column C "> 3 to 6 PM" , Current Date and time between 6 to 7 PM in Column C result should be " > 6 to 7 PM", after 7:00 PM , in Column C should be "> 7:00 PM onwards.
when time > 14 Hours it should be >14 Hours and continue the this logic to >24 and >48 hours.
I would be very thankful to help me devolope the formula for this.

Sorry, for not using the XL2BB becuase of the admin Limitations.

Thanks

 

[jdellasala]

Thanks for other versions, but Vlookup and lookup version not working for me for unknown reason. I am trying to figure it why VLOOKUP is not working.

I didn't save the original work, so I copied it from here. WHAT A MESS! Formulas and even values came in as text. It needs a lot of work, but mostly just selecting a cell, hitting F2 to edit the formula/value, and then hitting [Enter] to get it back to where it needs to be!

 

[Dave Patton]

Try downloading the Vlookup version from post #17 to a clean sheet.

Click on the icon below the f(x) in the header, move to your sheet, and paste.
You can review the formula with Formulas Evaluate Formula.