Forum Discussion
Solved
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.
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.
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?
Could you attach a small sample workbook demonstrating the problem (without sensitive data)?
- Thanks so much for your help
- Wow. You are amazing Hans
