Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
58
Views
Topic starter
| 20181031T183138000 |
| 20181031T183138100 |
| 20181031T183138200 |
| 20181031T183138300 |
how can I convert this time[iso-utc] into the date, time with milliseconds into a single cell? How do I get the milliseconds to change from 000 to 900 and then repeat the milliseconds cycle? I been trying for weeks
Posted : 08/12/2022 4:32 pm
Hi Floyd,
Welcome to our forum! Can you please upload a sample Excel file that shows the desired result for the examples above. I'm not sure I should interpret the numbers after the T as the milliseconds or not.
Thanks,
Mynda
Posted : 08/12/2022 9:13 pm
