How to exclude Unscheduled Time Off from Total Hours?

Find resources designed to help you get the most from Replicon

An employee is scheduled to work 8 hours a day and hence in a week works 40 hours. He works 8 hours from Monday to Thursday and on Friday takes a time off which is Time Off without pay. Hence he would be paid only for 32 hours.
The administrator wants to get this in the report which would clearly show that the total hours that he has worked is 32 hours and 8 hours is Time Off without Pay and he would be paid only for 32 hours.

To achieve this please follow the steps given below:

  • Login to Web TimeSheet with the Administrator privileges
  • Expand TimeSheet Setup and select Paycode
  • Add a Paycode by the name of Time Off without Pay and make sure the Paycode multiplier is 0
  • Expand Time Off types and then add a Time Off type by the name of Time Off without Pay and assign the new created Paycode to it.
  • Save the changes.
  • Expand Users and Departments and select any one user and assign this Time Off type to the user.
  • Save the changes.
  • Next, go to the Time Off Calendar and book a time off and select the time off type as Time Off without pay and Submit it.
  • After the above steps are done go to TimeSheet detail report and follow the steps given below.

To get this Time Off excluded from the Total Hours please follow the steps given below:

  • In the Reports Section, select TimeSheet Details Report.
  • Click on Settings and then scroll down and below Custom Column click on Add.
  • Name the Custom Formula as Total Hours (since it would not take into consideration the Time Off without Pay)
  • Assign the formula as given below

    • if((TimeOffHours=0),NonProjectPeriodHours,if((TimeOffName="Time Off – Without Pay"),0,TimeOffHours))
  • In the Column make sure that the Time Off Hrs, Time Off Type, and User Name is checked.
  • Save and run the report.


Start a free Replicon trial today based on your business needs

Start Free Trial