Hey Lauri 🙂
I think the easier way to do this would just be to change the settings on the field. If you click the column, you should be able to change from Local to Friendly to get the date written out. You can also change from 24 hour to 12 hour with am/pm if you'd like.
If you'd rather do it with a formula, you may need to try setting the timezone. I've had to set the timezone in every date/time formula I've done with AT.
