I have a Google Spreadsheet with a date row in UTC time, such as
I want GMT+2 local time, so how can I convert the date in Google Drive?
And, if not possible, is there a way to do that in Excel, at least?
migrated from superuser.com Dec 14 '12 at 14:55
This question came from our site for computer enthusiasts and power users.
In MS Excel try this:
Same with Google:
Adds 3 'Hours', 0 'Minutes', 0 'Seconds' to the date/time value of A1
Additionally if only you use the main sheet you can go into the sheet settings and change it's timezone accordingly.