If you just wish the time to display, set the cell format to Time.

If you wish to use the time portion then =A1-Int(A1) will give you the
time that was in cell A1

Hope this answers your question.


Hani Muhtadi Wrote:
Hi Folks,

I could do with some help here please. I am trying to extract the time
only from a cell that has both the date and the time. Can anyone
suggest a solution?

Thanks in advance.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=466177