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?

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.

6 Replies
best response confirmed by chris7749 (Copper Contributor)
Solution

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

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.

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

Wow. You are amazing Hans

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

Thanks so much for your help

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

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

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

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

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

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

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

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.