I have a custom list in SharePoint with two Date and Time columns, namely
EndTime. Now I want to calculate the difference between them, so I created a new calculated column
Length and entered the formula like this:
It should return the duration between
EndTime in minutes. But in some situations, the result is off by 1. E.g. 8:30PM - 6:30PM = 119 minutes. I believe this must have been caused by floating point rounding error. But how do I prevent it? Or should I use a formula other than
Edit: I saw this exact same formula here, under Date and time formulas > Calculate the difference between two times > Total minutes between two times. But that only added to my confusion, why is something Microsoft used as an example not working as intended?