Timevalue question

[MikeBres]

I'm trying to use the Timevalue function, but it doesn't
give me the results I expect. So obviously I don't
understand it. Here's what happens. I have a date & time
in text form, I reference the cell using TIMEVALUE(C3).
I get back an error, #VALUE. Puzzling since the
instructions in the help file clearly say that the
TIMEVALUE function will ignore the date part. So I tried
just inputting it directly, TIMEVALUE("21:48"), that
works. Okay, so then I parse out the time value, 21:48,
and try it with a reference again, TIMEVALUE(C4). Again
I get the #VALUE error. Grrrr! What am I missing here?
Mike

 

[Frank Kabel]

Hi
what is in C4. If there's already the time value 21:48 it won't work

 

[Guest]

C4 contains the time portion of the date that I extracted
using the right function.
C1= 10-06-2004 21:48 'in text format
C4=RIGHT(C1,LEN(C1)-FIND(" ",C1))

Mike