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:

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk