How to create report calculating hours worked on holidays

  • 1
  • Problem
  • Updated 4 years ago
  • Acknowledged
I am having trouble creating a report that will calculate the hours worked on a holiday (for each user). In a "Timesheet Day" template report, I have created a custom column with the following formula:
However, this does not work. I think because when our employees record their worked hours on a holiday, it is booked in a separate entry from the holiday hours on the same date. Therefore, HoursWorked is always 0 for the holiday entry (while there are still HoursWorked on a separate entry for the same date.)
Thank you for any guidance.

Photo of Ben PS

Ben PS

  • 2 Posts
  • 1 Reply Like

Posted 4 years ago

  • 1
Photo of Aashnee Kamboj

Aashnee Kamboj

  • 1657 Posts
  • 116 Reply Likes
HI Ben,

Thank you for using the Replicon Community!

I would like to have a quick call with you. Can we schedule a call for discussing the issue