Skip to main content

All Questions

Tagged with
3 votes
1 answer
22k views

Excel - UTC to EST Formula

I have a UTC timestamp that looks like this in Excel: 2022-10-28T18:12:23.603Z I need the information to appear as 10/28/22 hh:mm:ss AM/PM format but I need it to come out in EST timezone. Right now, ...
Sheri Morgan's user avatar
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 ...
Eleopd's user avatar
  • 1