One approach would be add a column and use a formula like =B2- (7/24). In this example it changes the time to my local timezone which is UTC -7. When the result causes a date change it appears it would need some additional formula work to get it functioning.
Ryan / Meraki SE
If you found this post helpful, please give it Kudos. If my answer solved your problem click Accept as Solution so others can benefit from it.