Time Difference Macro and Chart to display

Hi,

I have made clear brief in my attached excel workbook for calculating time difference and manually entered the slab of mins where dat would need to be automated.

Also i would require a Chart to display the no of cases in Bucket wise as shows in attached workbook.

Really appreciate !!!!