Date/hour format

New Contributor

I imported a csv. The date/hour format is quite special: 2017-07-07T17:42:42.931Z,055

What would be the custom format for this?

Thanks for your support. 

4 Replies





You need to convert this timestamp to a proper date/time so that Excel can read it.


So I suggest this formula:

=REPLACE(SUBSTITUTE(A2,"T"," "),SEARCH("z",A2),LEN(A2)-SEARCH("z",A2)+1,"")+0

Special Timestamp.png


Also, you need this custom format to be applied to it:

m/d/yyyy h:mm.000


Hope that helps



as variant that could be


assuming the timestamp is always in same format. Another assumption we use date/time for UTC+0 time zone as it is in timestamp. If conversion to local time zone is required that will be more complicated.

have no idea what the number after the comma means (055 in this sample).


Thank you @Haytham Amairah !

Thank you for your time.
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies