Summary:
There are a few hourly employees working for my organization. I would like them to accrue vacation time off hours only on the basis of total hours for the timesheet period.

Resolution:
Web TimeSheet does not support accrual of vacation time off hours on the basis of total hours for a timesheet period. To work around the issue, you can use the custom column feature in Web TimeSheet. Inclusion of the following formula in the custom column will allow the report to calculate the time off accrued by an employee on the basis of the total hours for the timesheet period. The time off accrued by the employee has to be manually updated in his time off policy.

For example if there are 8 hourly employees, please create a custom column with the following formula.

If(UserFirstName="Rob" &&TotalPeriodHours<=40,(TotalPeriodHours*1.54/40),

If(UserFirstName="Jimmy" &&TotalPeriodHours<=40,(TotalPeriodHours*1.66/40),

If(UserFirstName="Frank" &&TotalPeriodHours<=40,(TotalPeriodHours*1.66/40),0)))

If(UserFirstName="Rob",if(TotalPeriodHours<=40,(TotalPeriodHours*1.54/40),1.54),

if(UserFirstName="Jimmy",if(TotalPeriodHours<=40,(TotalPeriodHours*1.66/40),1.66),

if(UserFirstName="Jimmy",if(TotalPeriodHours<=40,(TotalPeriodHours*1.66/40),1.66),

if(UserFirstName="Jimmy",if(TotalPeriodHours<=40,(TotalPeriodHours*1.66/40),1.66),

if(UserFirstName="Jimmy",if(TotalPeriodHours<=40,(TotalPeriodHours*1.66/40),1.66),

if(UserFirstName="Jimmy",if(TotalPeriodHours<=40,(TotalPeriodHours*1.66/40),1.66),

if(UserFirstName="Jimmy",if(TotalPeriodHours<=40,(TotalPeriodHours*1.66/40),1.66),

if(UserFirstName="Frank",if(TotalPeriodHours<=40,(TotalPeriodHours*2.07/40),2.07),0))))))))