Just make a copy of the cell (e.g. A1) then in B1 insert =A1 and format B1
like "h:mm"
Stefi


€žHani Muhtadi€� ezt Ã*rta:


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.


--
Hani Muhtadi
------------------------------------------------------------------------
Hani Muhtadi's Profile: http://www.excelforum.com/member.php...o&userid=26794
View this thread: http://www.excelforum.com/showthread...hreadid=466177