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?