Is there a formula that I can enter that will take NOW() for Eastern Standard Time and convert it to PST? (which would also take into account producing the previous day until 3:01 AM EST)

Any ideas would be appreciated.

Thanks