Wrong Date Showing, Seems to be 4 hours off the difference between GMT and my Time Zone.
As can be seen in the attached screenshot I have data that is brought into the sheet from a web form. A time and date stamp is attached at posting (this time and date is correct) however, the date column beside it that is derived from the function Created is not correct is not.
This issue is on all of my sheets and seems to be out by 4 hours. This time difference is the same as the difference between my local time (AST) and GMT.
All my apps are set for AST.
Does anyone have any idea what could be causing this?