I’ve been making great progress with my app here and I’ve started live testing, and I’ve encountered an issue here that I have not been able to figure out at all.
Context: My team has meetings with clients and I want them to register meetings after they’ve been held. There’s a form to register the meeting, which includes a start date/time picker and end date/time picker.
When creating the meeting, I want the system to automatically calculate the number of hours used and subtract these from the client’s total hours available.
Setup: Custom form, start and end date time pickers are two separate inputs, button to create new session record. Custom formula for duration field takes the end time and subtracts the start time.
Result: I consistently get the correct number, but about half the time it’s negative and I cannot figure out why this would happen.
Here are 4 examples, the first one was an hour and 15 minutes so that’s why it’s a bigger value, which is fine. But why negative?
Meanwhile the same person registered two sessions with the same client, one came out negative and one positive.
Here’s how the data is set to collect and generate the record
