Google Docs: Add 3 hours to Date value (DD/MM/YYYY 00:00:00)

Question

I have cells with Dates in this format: DD/MM/YYYY 00:00:00 and I want to add 3 hours (I'm in a different GMT zone)

Is possible to use Dates in a formula?

Something like: 30/12/2012 22:15:00

Should become:

31/12/2012 01:15:00

Thanks!

Answer 1

All date/time values in spreadsheets are internally handled as floating point values. To add 3 hours to a date/time just add (3/24) to the original date/time.

=F3+(3/24)

This also works in MS Excel.