Convert a date in Google Spreadsheet?

Question

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?

ymn · Accepted Answer · 2012-12-14 08:52:13Z

up vote 3 down vote accepted

In MS Excel try this:

=A1+TIME(2,0,0)

answered Dec 14 '12 at 8:52

ymn
1483

2

It's the same for Google Spreadsheet. Straight forward solution!! – Jacob Jan Tuinstra Dec 14 '12 at 9:15

migrated from superuser.com Dec 14 '12 at 14:55