ROUND up to days?

[Brainfire]

Hi, everyone...

I've just started using Access, and now have a field that I need to
round up to days. The field is in hours, the smallest figure being
0.01 and the largest 2400. What I need to do is round this up to days
without adding a day to the whole numbers, which is proving impossible
for me!

Total newbie help required!!

Thanks.

[Gord]

On Mar 28, 7:46 am, "Brainfire" <[e-mail]:

Hi, everyone...

I've just started using Access, and now have a field that I need to
round up to days. The field is in hours, the smallest figure being
0.01 and the largest 2400. What I need to do is round this up to days
without adding a day to the whole numbers, which is proving impossible
for me!

Total newbie help required!!

Thanks.

If "x" was the value you wanted to convert, then this should work:

Int(((x*3600)+86399)/86400)

[Tom]

If x is the field value, try -(int(-x/24))...

>From Help "if number is negative, Int returns the first negative

integer less than or equal to number"

Wish I could say I thought of this trick - alas I am not that smart.

Tom

[engles]

On Mar 28, 2:58 pm, "Tom" <[e-mail]:

If x is the field value, try -(int(-x/24))...

From Help "if number is negative, Int returns the first negative

integer less than or equal to number"

Wish I could say I thought of this trick - alas I am not that smart.

Tom

int(x + .99999) should work too I would think. It's not nearly a
clever as Tom's suggestion tho.

-- Larry Engles

[Brainfire]

Yup, got it sussed - thanks guys.