Hi folks,
I’m trying to create a formula that will return a date and time that is a pre-designated time the next day.
For example:
Jan 12, 2019 @ 2:19 PM
AND
JAN 12, 2019 @ 4:00 PM
Would both return a date of JAN 13th, 2019 @ 5:00 PM
I can add 24 hours with the DATE ADD formula, but is there a nested formula I can use to modify all times to a predetermined time?
The purpose of this formula is to create a due date field, that is a set time one day after all form submissions that populate my table.
Thanks!