Calculating end date, given start date, start time, end time
I thought I'd be able to think through this, but I keep getting stuck. I have a need to enter in a start date, start time, and end time. Then based on the elapsed time between the start time and end time, calculate the end date and stick it in a date field.
I want the user to be able to just enter in start, and end times (or pick from a list), and pick a start date.
Example: event begins at 9pm on 5/9/2015. Event is scheduled to end at 1AM. I don't want the user to have to enter in the end date. I just want the system to handle it. Can you add elapsed time to a date to get a another date?