Locale

Date and time values add-on inserts are in the time zone and in the format you select in the spreadsheet settings. Go to File -> Spreadsheet settings to adjust these settings.