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

H

Hani Muhtadi

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

Bryan Hessey

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

Stefi

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