Skip to Content
0

Formula to Convert AZ time to Pennsylvania Time

Apr 10, 2017 at 08:58 PM

21

avatar image

I have a database, that I do not manage. In the database are several date and time fields, which are in Arizona time (who does not use daylight savings). I am in Philadelphia, Pennsylvania. We have EST & EDT. I need to find a formula that will allow me to have the date and time display in Pennsylvania time, correctly, no matter when the report is run or for what time period it is for. We consistently run reports for data over months and years at a time so a basic "add a few hours" would not work :-(

I have been googling like crazy and I am not finding anything. Unfortunately my CR skills are self taught so what I have found has been a little foreign to me.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers