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:

EST =Handshake Column-(5/24)

CST =Handshake Column-(6/24)

PST =Handshake Column-(8/24)

PDT =Handshake Column-(7/24)

MST =Handshake Column-(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