This spreadsheet shows how you can use the date and time formulas.
It includes examples for retrieving the current date/time in multiple time zones and converting UTC date/times between time zones.