order times

[shaqbone]

I am trying to graph what time we place orders. I have it time stamped down to the second 14:25:10. My initial thought was to right an "if" statement to consolidate the times into band; however, I can not get it to recognize the time?

=IF(F2<8,8,IF(F2<10,10,IF(F2<12,12,IF(F2<14,14,IF(F2<16,16,IF(F2<18,18,20)))))))

I then changed the 8,10,12 etc to 8:00, but I am lost!
Any ideas?
Thanks,

[shaqbone]

FYI

I found a solution:

=MROUND(F2,60/(60*24))

Time rounded to the hour.