I have cells with dates in this format:
DD/MM/YYYY 00:00:00 and I want to add 3 hours because 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
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
See also: Convert a date in Google Spreadsheet?
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.
I do this for my work schedule to track different projects:
Three columns A B C where column A is text, B is hours, C is minutes.
In Time 8:00 AM is B2
WLI 3 15 ADMS2 2 0 O&M 2 30 Break 0 15 Total 7 45
Out Time 3:45 PM
=SUM(B3:B6) for hours,
=SUM(C3:C6) for minutes