Converting dates and times in Handshake reports


Rob Midson -

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.

Excel formulas for converting this date(in Daylights Savings Time):

EST =CellName-(5/24)

CST =CellName-(6/24)

PST =CellName-(8/24)

PDT =CellName-(7/24)

MST =CellName-(7/24)
 

Format cells in Date / Time format of your choice:

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