Using RIGHT Function to extract time values in date / time field

[endora75]

Hello everyone:

I am trying to use the RIGHT function to extract the time from a date / time field. I've also attached the sample Excel file.

Example from Cell B3:
3/8/10 11:55 AM

I tried the RIGHT function in this manner (Cell C6):
=RIGHT(B1,8)

But, it gave me this answer even though I formatted it as "Time" (Cell C6)
68829282

It seems to me that the RIGHT function can only be used on alphanumeric characters. Is there another function or way to extract the 11:55 AM from the cell?

Thanks in advance for your help.

[sweep]

How about right click > format >number > time "hh:mm AM/PM" on the cell containing the date, or

=TEXT(A1,"hh:mm am/pm")

[JeanRage]

Hi,

You are dealing with a format issue ...

In cell C6, you can have =B3 and format this cell as Time ...

HTH

[ChemistB]

Or if you want to keep it as a number, lets say your date/time is in A1

=A1-INT(A1) and format the cell as time.

[endora75]

Thanks to everyone who has responded so far. I have another question that I'll post as a follow-up.