ExcelBanter - View Single Post

FSt1

hi

regards
FSt1

"LonnieJo" wrote:

Thanks but changing the formatting didn't help. Using the new formula didn't
help either. Is there somewhere I can send you a sample sheet so you can see
what is happening?
--
Thanks!
Lonnie Jo

"FSt1" wrote:

hi
i think you have run into a format problem. reformat your date/time to
general and you will see what i mean. with formating, what you see on the
screen may not be what's in the cell. fomating does not change data, it just
changes the way it looks.
try a fomula like this....
=F2-DATE(YEAR(F2),MONTH(F2),DAY(F2))
you will get something like
1/1/1900 15:55 so change the way it looks..uh...reformat to hh:mm.

regards
FSt1
"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