Question: How can I change extract the time value from the cells in D column?

[chris7749]

Question: How can I change extract the time value from the cells in D column? 

The expected outcome is to show have the time value shown in 24 hrs format.  

[#2 · Accepted solution]

@chris7749 

See the attached version.

It's the same as your previous question, with one difference: the space between the date and the time is a non-breaking space, so we had to take that into account.

[#3]

Wow. You are amazing Hans

[#4]

Thanks so much for your help

[#5]

I tried applying the same function to my original file but I'm getting #VALUE error. Could you please advise?

[#6]

@chris7749 

Could you attach a small sample workbook demonstrating the problem (without sensitive data)?

[#7]

@chris7749 

Or, if on 365/2021

=TIMEVALUE( LEFT( TEXTAFTER(D2, CHAR(160) ), 10) )