SOLVED

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

Copper Contributor

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.  

chris7749_0-1694091429911.png

 

6 Replies
best response confirmed by chris7749 (Copper Contributor)
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.

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

@chris7749 

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

@chris7749 

Or, if on 365/2021

=TIMEVALUE( LEFT( TEXTAFTER(D2, CHAR(160) ), 10) )
1 best response

Accepted Solutions
best response confirmed by chris7749 (Copper Contributor)
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.

View solution in original post