I have 2 date fields that calculate the difference between days, and give the total in another field. (thanks, Qrules)
I have another field for time. If the time is greater than 12:00 it subtracts half a day from the total.
The problem I'm having is, if I change the time to another time greater than 12:00 (noon), it will subtract again, which is not what I want. And if I change the time to be less than 12:00, the previous calculation will still be there, obviously.
What would be the best way to approach setting the total depending on what the time field is? Should I use an eval function or something?