All Questions
Tagged with utc microsoft-excel
3
questions
0
votes
2
answers
1k
views
How can I remove the letters “UTC” from the time in a column of cells with date and time entries?
I have cells in a spreadsheet with the date and time in UTC (over a thousand of them).
I want to remove the letters UTC as I need to import the document elsewhere and it doesn’t work with the letters ...
- 1
8
votes
3
answers
87k
views
How to convert UTC to typical date format in Excel?
I have this UTC column called Timestamp. It looks like this.
2019-06-27T23:01:12.1024861Z
How do I convert it so it looks like this in Excel?
06/27/2019 23:01:12
If there is a formula that would ...
0
votes
0
answers
307
views
Format Excel datetimes with fixed widths and typical software formats
How can Excel be used to format dates with fixed widths using formats typical to software applications (MySQL DATETIME format, ISO 8601, RFC3339)? While it would be "nice" to convert to UTC, I am ...
- 1,691