Modulo and floor

roman.jeckelmann1 · 2025-01-08T14:46:02.352Z

Hi everyone

I found a weird behaviour. In my database I have a record of -4’350 (datafield: number and represents the “total minutes worked”)

Now on the “customer app” (website) I want to show it in the hh:mm-format.
So I defined the following:

image339×164 9.52 KB

I would expect -72:30, but I get the value:

How can I manage that? Many thanks for your support

geesonofgee · 2025-01-08T15:06:56.638Z

I don’t know if I get you correctly.
Are you trying to display the remainder of the total minute ™ after dividing ™ by 60, cus i see that you make use of ← modulo->?
If you simply want to get the total minutes converted into ours with that format, you just need to divide the ™ by 60, :floor it and format it as…

Hope this helps!

rpetribu · 2025-01-08T15:43:13.101Z

This is mathematical problem and is happening because you have a negative number.

:floor will bring the value to the closest lower integer number. The closest lower integer number after -72,5 is -73.

-73 is lower than -72

In your case, -72 is a higher number.
So you will need to use :celling

roman.jeckelmann1 · 2025-01-08T15:55:55.489Z

You are right. So then I would need to use ceilling when the value is negative and floor when it is positive. But is there a proper way to display hh:mm when I have a total of minutes? So another way as I have done it?

rpetribu · 2025-01-08T19:49:40.466Z

The only problem I see in your image is that you need to remove the minus sign before the minutes.

roman.jeckelmann1 · 2025-01-09T16:37:41.771Z

How would you do that? Because the initial value is -4350 and I would like to show the hours and the minutes (should then also be minus).

So the result should be -72:30

roman.jeckelmann1 · 2025-01-09T17:13:56.156Z

I solved it like this but it is not proper:

image308×256 14.3 KB

I used ceiling with the condition that the value is under zero (0). And with the find&replace I removed the minus after the “:”

rpetribu · 2025-01-09T17:15:56.404Z

You could aslso multiply the minutes by -1

system · 2025-03-19T14:46:34.113Z

This topic was automatically closed after 70 days. New replies are no longer allowed.