Locale

Date and time dynamic values are created in the time zone and in the format you select in the spreadsheet settings. To change time zone or locale go to File -> Spreadsheet settings and choose time zone and locale you want to use.