For instance, given a string like 18:40:59.795Z
I'd like to be able to call TOTIME(A1, "HH:MM:SS.mmmZ")
or something like that. Time conversion in Excel is a pain; every time I need to do it I have to do string parsing with MID
etc. Surely there's a better way?
MacOS preferred.