AngelikiEfthCopper ContributorNov 12, 2020SolvedExtracting 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!!! PReaganNov 12, 2020Hello AngelikiEfth, As a variant, that could be:=TIMEVALUE(MID(A1,FIND(":",A1)-2,8))
PReaganNov 12, 2020Hello AngelikiEfth, As a variant, that could be:=TIMEVALUE(MID(A1,FIND(":",A1)-2,8))
PReaganNov 12, 2020Hello AngelikiEfth, As a variant, that could be:=TIMEVALUE(MID(A1,FIND(":",A1)-2,8))
PReaganBronze ContributorNov 12, 2020Hello AngelikiEfth, As a variant, that could be:=TIMEVALUE(MID(A1,FIND(":",A1)-2,8))
AngelikiEfthCopper Contributor to PReaganNov 12, 2020Thank you lots!!PReaganBronze Contributor to AngelikiEfthNov 12, 2020AngelikiEfth Happy to help!
