Hi All,

In a columns I have the time like below
18:10
19:25
19:52
20:15
21:45
00:12
00:23
00:55
01:45
02:34
03:36
04:14
05:18
06:17

I want to show the time 6-8 (18:00-20:00) as 1, 8-10 (20:00-22:00) as 2
10-12 (20:00-00:00) as 3, 00:00-02:00 (00:00-02:00) as 4 and so on...

will I have to write macro? or is there any better way to that?

Please help!!