Good afternoon folks...
I'm having a little problem in numbers with a formula (INT), but the excl works perfectly.
I want to use this formula for calculating (a duration), and another column to calculate the decimals for that hour, using the formula INT.
please help me...
thanks...
MacBook
Hi Mauricio,
From the description of INT in the Function Browser:
The INT function returns the nearest integer that is less than or equal to the number.
The error message shown in your screen shot explains the cause of the error more directly. Translated via google translate, the English version is : "INT argument 1 cannot be a duration"
Apparently, the value in J4 is a Duration value. It can be converted to a number representing that number of Days or that number of hours using DUR2DAYS, DUR2 HOURS or one of the other DUR2 functions.
"excl works perfectly" has no significance in this question for two reasons:
Numbers is not MSExcel, nor is it a clone of Excel.
Excel does not support Duration values, so it never presents Duration values to the INT function.
Regards,
Barry
could you help me please
It is confusing, because when I put something other than duration, the formula fails and says: In the INT formula it only means, date or Duration.
However, when I put the formula as a duration, it doesn't accept it.
I need to know the decimals in 1 hour.
thank you.
I got it...
The DUR HOURS function, solved the problem ...
Formula INT
