Date/Time math

[MattLB]

I have a “Date” and I want to ‘add’ time to it.

For example the Due Date (from a Date Picker) is May 13 and I want to add either 7 AM or 12 PM or 5 PM to the Due Date and create a “Due Date/Time”.

I can’t get ‘Date Math’ to work.

Thanks

[Robert_Petitto]

To add time, start with a date in a date time column. Add a math column and add a value in days (eg. +1 = 1 day, + 0.5 = +12 hours).

[MattLB]

Using the “% of the day” in the date addition did the trick.