Extracting Time from a cell that has both the date and the time
 

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. :confused:


--
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

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. :confused:


--
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

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. :confused:


--
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

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. :confused:


--
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