Hi,
i can’t get the integer part of the result of a division.
The aim is to transform for exemple 5400 (a number representing seconds) in that string: “1h 30mn”.
To get the hours, i divide 5400 by 3600. The result is 1.5.
Using the ROUND function does not work: i get “2” when i want “1”.
Same thing with the number formating options.
It may be obvious but i can’t find a way!