You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Formula INT


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

Posted on May 4, 2020 1:56 PM

Reply
3 replies

May 4, 2020 9:03 PM in response to mauriciopilotoo

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.

  • INT(num-to-round)


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



Formula INT

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.