How to Convert Dates and Times in Handshake Reports

Tawnya -

Would you like to convert the dates in a report that you have downloaded in Handshake? All dates that are pulled from Handshake are in UTC time which is Coordinated Universal Time.

If your download includes the text "UTC" at the end of your date/time cell, you will first have to remove that text from each cell. To do this, highlight the cells with your dates/times and utilize the Find and Replace feature within Excel to find the "UTC" text and replace it with nothing:

Next, format those cells in the Date / Time format of your choice:



Finally, use the Excel formulas listed below to converting your dates (ST = Standard Time / DT = Daylight Savings):

EST =CellName - (5/24)

EDT =CellName - (4/24)

CST =CellName - (6/24)

CDT =CellName - (5/24)

PST =CellName - (8/24)

PDT =CellName - (7/24)

MST =CellName - (7/24)

MDT =CellName - (6/24)

Was this article helpful?
2 out of 21 found this helpful
Have more questions? Submit a request