 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.

6 Replies

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

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

best response confirmed by AngelikiEfth (Occasional Contributor)
Solution

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

Hello @AngelikiEfth,

As a variant, that could be:

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

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

ED

Ignore. I was sleeping.

/ED

Is the data "real" excel data/time or a textstring?

If real excel-time

=MOD(A1,1)

And change the number-viewing format to something appropriate (ctrl+3)

If it is a textstring. extrakt text from letter 12 and 8 forward

=MID(A1,12,8)

And if you want to be able to calculate. Transform to proper Time-data

=TIMEVALUE((MID(A1,12,8)))

(ctrl+3)

Thank you lots!!

thank you!!

Happy to help!