Show Start and End time on a SharePoint calendar

If you have ever wondered if  it would be hard to show both the start and end times on a SharePoint calendar, stop wondering!

This can be performed in six simple steps.

  1. Create a calculated column.  Name the column “Time of Event”
  2. Insert this formula: =TEXT([Start Time],”h:mm AM/PM”)&” – “&TEXT([End Time],”h:mm AM/PM”)&” : “&Title
  3. For data type, select “Date and Time”
  4. For date and time format, select “Date and Time”
  5. Click OK
  6. Modify Calendar View:  Change monthly view title under calendar columns to “Time of Event”

The new entry will look similar to the image below: