I have a Google Spreadsheet with a date row in UTC time, such as 12/6/2012 11:14:32
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?
Google Sheets – How to Convert Date
dategoogle sheets
Related Topic
- Google Sheets Date Format – How to Format Dates in Spreadsheets
- Google-sheets – Date Formatting in Google Spreadsheet
- Google-sheets – Customizing filter in Google Spreadsheet
- Google Sheets – How to Format Date
- Google Sheets – How to Convert Month-Year Text to Date Format
- IFTTT – How to Add URL from Facebook Status Update to Google Spreadsheet
Best Answer
In MS Excel try this:
=A1+TIME(2,0,0)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.