B
bartman
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?
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?