Hi All,

I'm hoping this will be an easy answer, heres my query...

00:01 - 12:00 = 1, 12:01 - 18:00 = 2, etc etc

A B
12:45 2
11:41 1
00:25 1
13:15 2
14:54 2

Now from the criteria above I would like column B to show 1's & 2's etc etc.

Any ideas guys??

Thanks,
James.