suppose u have data in A1 3/3/08 15:55 , In B1 put =A1
Format cell for B1 | ctrl + 1 | format cell | category: Time | type :
HH:MM | ok



On Jul 10, 2:51*am, LonnieJo
wrote:
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!!!!!!!
--
Thanks!
Lonnie Jo