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?

End Time

End Time

Formatted Column of End Time

Work End Time

Work End Time Formula

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.

  • Not able to reproduce. Check your Regional Settings/Timezone settings. Also add End Time to the view to make sure its not using any Day Light Savings. – Amal Hashim Nov 26 '14 at 15:51
  • Okay it definitely looks like End Time is subtracting 1 hr from whatever is input. Does that mean it is using Day Light Savings time? If so, how can I turn this off? – ExceptionLimeCat Nov 26 '14 at 16:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.