Forum Discussion
Solved
Converting Timestamps
Hello, PC/Windows 10 Microsoft 365; Excel Version 2211 *I am not able to post a sample file (error message that .xlsx file not supported when I drag and drop)...here is a screenshot of the work...
Presuming the string is in A2:
This solution discards milliseconds:
=DATE(LEFT(A2,4),MID(A2,5,2),MID(A2,7,2))+TIME(MID(A2,9,2),MID(A2,11,2),MID(A2,13,2))
Presuming the string is in A2:
This solution discards milliseconds:
=DATE(LEFT(A2,4),MID(A2,5,2),MID(A2,7,2))+TIME(MID(A2,9,2),MID(A2,11,2),MID(A2,13,2))- Answered! Thanks - this worked like a charm!
- You're welcome! Glad it worked.
