Rounding up numbers produced by a query

[Guest]

I have a table in which employees log the time spent on a project in minutes.
Clients are to be billed in 1/10 hour increments, and minutes need to be
rounded up to the nearest 1/10 hour. For example 8 minutes in employee time
becomes 2/10 hour when billed. I have a query that creates a log of employee
time expressed in 1/10 hour increments, but the results are rounded off, not
up, thereby making 8 minutes 1/10 hour. Additionally, the end of the bill
must derive its total from the rounded up figures, not the raw figures. Any
suggestions?

 

[Guest]

Set up a cross-reference table that shows a low/high for each tenth of an
hour. Such as:

StartMin EndMin Tenth
0 6 1
7 12 2
13 18 3

Then compare the minutes entered against StartMin/EndMin to determine Tenths
of an hour.

Good luck.

Sharkbyte

 

[Van T. Dinh]

Use the expression
- Int( - [RawMins] / 6) * 6

To round up to the next 6 mins (1/10 hour) interval. For example:

?-Int(-8/6) * 6
12