Countymnca
Technical User
Hello,
I have a tough one that I cant seem to solve. Below are the details:
We have a 3rd party vendor SQL app that does time and attendance (among other things) and our employees track their time via project codes depending on what they are working on. The problem I am having is that when an employee works on a project for 20 minutes, their time is shown as .33. (We use 1 minute rounding). If they have several different 20 minute segments on different projects, their time for their 8 hours day could be shown as:
2.33
2.33
3.33
Each time calculation is rounded to 2 places, so the .0033333 for each is lost. The total for the day is not calculated, but our accounting section looks at the above entries and reports that .01 is missing for the day.
My thought to address this is to create a query to check the results table for employees and days that total to 7.99 and then run an update query to update the first row to add .01 to whatever it has. That would change the timesheet report to displaying:
2.34
2.33
3.33
Is there another way? Other ideas?
Thanks
I have a tough one that I cant seem to solve. Below are the details:
We have a 3rd party vendor SQL app that does time and attendance (among other things) and our employees track their time via project codes depending on what they are working on. The problem I am having is that when an employee works on a project for 20 minutes, their time is shown as .33. (We use 1 minute rounding). If they have several different 20 minute segments on different projects, their time for their 8 hours day could be shown as:
2.33
2.33
3.33
Each time calculation is rounded to 2 places, so the .0033333 for each is lost. The total for the day is not calculated, but our accounting section looks at the above entries and reports that .01 is missing for the day.
My thought to address this is to create a query to check the results table for employees and days that total to 7.99 and then run an update query to update the first row to add .01 to whatever it has. That would change the timesheet report to displaying:
2.34
2.33
3.33
Is there another way? Other ideas?
Thanks