Scenario:
The administrator wishes to to report on the total hours worked in relation with the regular working hours and the following are the conditions for this scenarios,

  • If Total Hours is greater than Hours per day, total hours should be reported in the form Number of days + Number of hours.
  • If Total Hours is less than Hours per day, total hours should be reported in the form the Number of hours.
  • If Total Hours is equal to Hours per day, total hours should be reported as  one day in reports.

Hours Per Day =  Expected hours of work from the user
Total Hours = Total hours worked in a day by the user

Resolution:
Create a custom column in reports with the following code:

if (((TotalHours/HoursPerDay) * 100) >= 100, if (((TotalHours/HoursPerDay) * 100) = 100,(LEFT(NumberToText((TotalHours/HoursPerDay)),1) +" "+ "day"),LEFT((NumberToText(TotalHours/HoursPerDay)),1) + " " + "day" + " " + "and" + " " + LEFT((NumberToText((TextToNumber(RIGHT((NumberToText(TotalHours/HoursPerDay)),2))/100)*HoursPerDay)),1)+ " " + " " + "hrs"),(NumberToText(TotalHours) +" "+ "hrs"))

To know more about Custom Columns in Web TimeSheet, refer to the Related Items section below, in this knowledge base article.
 

Related Items:

What are Custom Columns?