I have a calculated column on a calendar that just formats the start time of an event. I am just using the TEXT function to format the time as
hh:mm but for some reason the output of the function is always 1 hour before the specified end time. Has anyone else experienced this issue?
Formatted Column of End Time
Work End Time Formula
In case you cannot see the screenshot the formula is as follows:
=TEXT([End Time],"hh:mm AM/PM")
This is definitely an issue with End Time. Every time I open an event to edit it, End Time is subtracted by 1 hour. I have no idea what is causing this.