Too late, you got both, but cell F2 gives just the time - see attachment in msg#2...
p45cal Today, 07:16 PMTime. Thank you for responding....
MonteJ Today, 07:12 PMTime only? or date & time?
In attached cell F2 has formula for time only from your text:
=TIMEVALUE(SUBSTITUTE(SUBSTITUTE(MID(SUBSTITUTE(TRIM(B2),"
It seems Power Query has a little problem. If an hour format is imported from an external workbook, it is displayed as date/time. That would still work....
pinarello Today, 05:15 PM
help with converting time from a text value
Would a Power Query solution be of any use?...
p45cal Today, 07:34 PM