Can I use Web TimeSheet reports to calculate timesheet hours approved on time and hours not approved on time?
Find resources designed to help you get the most from Replicon
I am the Web TimeSheet administrator for my Company. My Company follows semi-monthly timesheet period for all the employees. The first timesheet for a given month is normally approved within the same month and the second timesheet for the month may or may not be approved in the same month. If it is not approved in the same month, I would like to run a report which shows for all the users, timesheet hours approved on time (that is, timesheet hours approved within the same month) and timesheet hours not approved on time (timesheet hours approved in the following month). I have created a report based on TimeSheet Hours Details template and have incorporated 2 custom columns to achieve this.
Please find the formula for the custom columns below:
Approved on time:
Not approved on time:
The report works fine in that it shows timesheet hours approved on time and not approved on time correctly. However, if there are more than one timesheet approvers, the timesheet hours are duplicated. Please find attached the screenshot of the report for a user.
If there are more than one timesheet approvers and each of them approve the timesheet at different dates and time, the approval date/time column in the report will have multiple
values. Since the custom column uses the approval date/time field, the “Approved on time” and “Not approved on time” fields will show the timesheet hours multiple times.
There is no perfect solution to the issue. However, to work around the issue, please perform the following steps:
Not approved on time
Run the report. The Approval field will display the date of approval and both Approved on time and Not approved on time fields will display the timesheet hours approved on time and not approved on time respectively only once.