I have a txt file that I have converted to xls using the wizard. In a
date/time field is data like 3/3/08 15:55. I am using the function
=right(F2,5) to extract the time only. I want to be able to count how
many incoming data in 2 hour increments over 24 hours. When I do the
function it returns 44444 in this instance for the 15:55. How can I
correct this? It's driving me crazy... LOL.. THANKS!!!!!!!


One way:
=INT(TEXT(F2,"hh")/2)
gives an integer from zero to eleven: twelve two-hour increments.

Bear in mind that dates/times in Excel are just numbers that are specially
formatted. For example, 1/1/1900 0:00 is 1.00 and 3/3/08 15:55 is
39510.6631944444.