I have a calculation using Start time, and End time with End time – Start time which worked fine until I worked from 2:00 pm one day to 12:30 am. The result for that time span is a negative number -13.5.
Is there a way to address this with a conditional calculation?
If start_time < end_time, you know that there is an overflow. Using the IF(x;y;z) construct you can use separate formulas for both cases.
Cheers, Daniel
---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks
If you’re using Time fields, they are all on the same day.
You’ll want to use Date & Time if your duration might span over midnight.
.
