Change Time Zone

[ericlobobr]

I have a spreadsheet where the date and time that someone logs in automatically, I would like to know if you have the option of changing the time zone?

[Jeff_Hager]

I think the app: logins sheet displays UTC time. You can convert it to a true date/time value and just add the number of hours to offset to the timezone you want.

Date formatting

I don’t think Glide is saving it as a true date value. It’s appears to just be text. Try this formula. It strips out the T and Z, then converts it to a date value which can be reformatted using TEXT: =TEXT(DATEVALUE(MID(A2:A,1,10)) + TIMEVALUE(MID(A2:A,12,8)), "DD/MM/YYYY")