Hi Hani,

If the date cell is A1, format the destination cell with a suitable time
format and enter the formula:

=A1-INT(A1)

---
Regards,
Norman



"Hani Muhtadi"
wrote in message
news:Hani.Muhtadi.1v33mc_1126256719.5169@excelforu m-nospam.com...

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