Hi all, I am trying to find a way to identify the shift of a particular time
without the date. For example the shifts start at these times:
1 22:30
2 06:00
3 15:00

I would like a formula to show the shift number based on the time in the
spreadsheet, example:
Time Shift
06:36 2
07:03 2
11:13 2
....
15:45 3
17:56 3
20:27 3
....
23:06 1
01:30 1
05:55 1

What's is really frustrating is I found a formula to do this a few months
ago, and I just spent the last hour trying to find it again without any luck.

Thanks
Mike