Skip to main content
First of all I absolutely suck at creating formulas.  I need some help making a formula to auto fill my Start Date/Time and End Date/Time fields based upon a single Date field and a Start Time field and End Time field.

 

This needs to be done for two reasons and if anyone has other suggestions, I am open to them. 

 

1. I cannot find a way to limit the times displayed.  We have had numerous instances of Appointment Start Times as 4:00 AM rather than PM.  Nobody works at 4:00 AM thus I would like this removed.  So I created custom Start and End Time fields.

 

2. We recently setup an appointment reminder email using the Start Date and End Date fields and it is only displaying the Date rather than Date and Time.

 

 
11 件の回答
0/9000