Forum Discussion

AngelikiEfth's avatar
AngelikiEfth
Copper Contributor
Nov 12, 2020
Solved

Extracting Time from a Day-Month-Date-Time-Year value in Excel

I have a table with data like this: Wed Jan 23 23:58:50 2019. How do I extract only the time? Please help me on this. Most grateful!!!
excel
office 365
  • PReagan's avatar
    PReagan
    Nov 12, 2020

    Hello AngelikiEfth,

     

    As a variant, that could be:

    =TIMEVALUE(MID(A1,FIND(":",A1)-2,8))

     

HansVogelaar's avatar
HansVogelaar
MVP
Nov 12, 2020

AngelikiEfth 

Let's say you have a date+time value in cell A2.

In B2, there the formula

=TIMEVALUE(MID(SUBSTITUTE(G8," ",REPT(" ",255)),640,255))

and format it as time

  • AngelikiEfth's avatar
    AngelikiEfth
    Copper Contributor
    Nov 12, 2020
    thank you!!

Resources