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.
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.
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.
Originally Posted by Hani Muhtadi
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
>
>
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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks