int() function not working

[crywrite]

I need to turn 1.25 hours into 1 hour and 15 minutes.

I'm trying to use the Int() function to subtract the interger so I can calculate the remaining minutes.

But the Int() is not working consistantly. I have two records that have 1 hour and the first record with the int function returns 1 and the second returns 0. They are both just 1, not .999 or anything.

Why is the int() func. inconsistant?

 

[Naith]

Int does try to round to the next smallest integer, which is possibly why you're getting what you don't expect. Try Fix() or Truncate() instead.

Naith

 

[Reebo99]

Personally, when doing any calculations like this I use Truncate(), as follows :

({percentagefield}*60)-(truncate({percentagefield})*60)

in your example of 1.25, this would give you 15. Reebo
Scotland (snowed in)

 

[Reebo99]

Looks like you beat me to it Naith. Reebo
Scotland (snowed in)

 

[crywrite]

the fix() function is working.

Thank you very much!!!