Hello everyone, I’m trying to calculate the remaining minutes using the modulo operation in Bubble, but it’s not giving me the expected result. Here’s the logic I’m trying to implement:
- If the sum of worked minutes is, for example, 63, I want the result of
63 % 60to be3. - For a sum of
127minutes,127 % 60should give7.
However, in my setup, the result always comes out as 0, even when I expect a different remainder.
Search for Employees attendance: each item’s worked minutes:sum ← modulo → 60
It seems like the modulo operation is not behaving as expected. Can someone help me understand what might be going wrong, or suggest an alternative way to calculate the remaining minutes?
Thank you!