There's a better way to split that call log data, and it doesn't require Textsplit or a newer version of Excel. The FILTERXML workaround posted by GrimClippers11 is clever, practical, and exactly the kind of thinking that keeps older software productive. But the real opportunity here isn't about a single formula, it's about recognizing that the tools you already own can do more than you've asked of them.
GrimClippers11 is working with Excel 2019 and a column of timestamps like "2026-01-07T11:27:00." That ISO 8601 format is efficient for machines but a headache for analysis. The typical move is Text to Columns, a manual process. When you have dozens or hundreds of rows, that repetition slows you down. The FILTERXML approach wraps the time string in custom XML tags and uses the function to extract both date and time components. It works because FILTERXML is built into Excel 2019, it's not a cloud-exclusive feature. The formula shown splits the timestamp on the "T" separator, returning date and time side by side. To extract just the time, you would modify the XPath expression to target the second item in the resulting array, and then format that cell as a time value. It's a one-time setup that runs fresh every time the data refreshes.
What this means for you: legacy software does not mean limited workflow. Excel 2019 and earlier versions still include powerful functions like FILTERXML, INDEX, and nested IF statements that can handle most modern tasks if you know where they are. The trick is learning to stitch them together. GrimClippers11's problem is not unique, and the solution is not obscure. It just takes reading the documentation and testing a few variations. That's the kind of practical skill that returns time for weeks. The next step: apply the same logic to split phone numbers, address fields, or any structured text. Build a small library of these formula templates, and you turn a frustrating limitation into a repeatable advantage.