How to calculate the percentage of hours entered for a project per user?

Find resources designed to help you get the most from Replicon


  • User A is part of Project 1, Project 2 and Project 3.
  • User has entered 10Hrs for Project 1, 20Hrs for Project 2 and 20Hrs for Project 3.
  • Admin wants to generate a report giving him the % breakdown of the User's time consumed per project/task.


  • A custom column which has the Billable + Non-Billable Hrs as the numerator and Total Hrs Period as the denominator. 
  • Group the report first by username and then by project name to get the desired layout of the report.
  • Use the following formula in the report custom column,



Start a free Replicon trial today based on your business needs

Start Free Trial