Show current UTC time in a spreadsheet
Budget: $2 – $3 USD
This task pays $2 total for the first person with a solution that I have successfully tested.
How do I get the UTC time in cell B5 (shaded in yellow), to represent itself correctly regardless of the time zone of the viewer?
The unprotected cells are all editable here for testing.
https://docs.google.com/spreadsheets/d/1vL0bnZt2ukpM9dZpAEdSB8UTOKF1d2DzRWhfumFF4eA/edit#gid=352989457
Assistance is greatly appreciated.
How do I get the UTC time in cell B5 (shaded in yellow), to represent itself correctly regardless of the time zone of the viewer?
The unprotected cells are all editable here for testing.
https://docs.google.com/spreadsheets/d/1vL0bnZt2ukpM9dZpAEdSB8UTOKF1d2DzRWhfumFF4eA/edit#gid=352989457
Assistance is greatly appreciated.