I found some useful information at Is it possible to apply a timezone to a date in a scripted field? but it seems this approach is not best practice and has been deprecated.
I then stumbled upon https://stackoverflow.com/a/46830875 and was able to get it working with a small tweak
Just not sure how well this will scale.