I'll just add a quick note. When uploading sessions in bulk using the import template, your sessions will appear in the 24 hour (military) time format. I often add 3 columns to my import sheet when I'm building it for a quick visual check.
Column 1 for date: =DATE(YEAR(X0),MONTH(X0),DAY(X0)) where XO is the START DATE/TIME field
Column 2 for start time: =TIME(HOUR(XO),MINUTE(XO),0) where XO is the START DATE/TIME field
Column 3 for end time: =TIME(HOUR(XO),MINUTE(XO),0) where XO is the END DATE/TIME field
The above 3 formulas will allow you a quick visual check as you are building your upload sheet.
------------------------------
Brenda Ainsburg
Channel Program Manager
brenda.ainsburg@siemens.comSiemens Aktiengesellschaft
United States
------------------------------
Original Message:
Sent: 01-31-2020 16:02
From: Drew Norman
Subject: Changing Time Format to US PM/AM
How do you change the Time Format from military time to regular US AM/PM.
#Creating/ManagingEvents
#Miscellaneous
------------------------------
Drew Norman
Camunda Services GmbH
------------------------------