Below is a paste of what I had and the result. I put the exact formula in column C that is in Column B. I misstated in my previous email that =Text didn't work when it actually did. I'm not blonde btw, just tired.
A B C = formula in column B
10/27/2005 4:23 4:23 AM =TIME(HOUR(A2),....
10/27/2005 4:23 04:23:00 =TEXT(A3,"HH:MM:SS")
10/27/2005 5:07 1/0/1900 5:07 =MOD(A4,1)