Building a report to Calculate "Banked Time Earned" per day per employee

  • 1
  • Question
  • Updated 2 years ago
  • Answered
Need to calculate "Banked Time Earned" per day. I built a custom report, but do not know how to sum all PayCodeHours (time entered) to then deduct them from the TotalDayHours (time allowed each day before going into banked time). Can PayCodeHours be summed be added together in a custom report?
Photo of Dean

Dean

  • 22 Posts
  • 1 Reply Like

Posted 2 years ago

  • 1
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1560 Posts
  • 108 Reply Likes
Hi Dean,

Thank you for using the Replicon Community!

You can create a custom column that does this calculation for each row and then sum that column up.

Thanks,
Aashnee Kamboj
Photo of Dean

Dean

  • 22 Posts
  • 1 Reply Like
Hi,  I created the custom column already but that is where i wanted to have it sum the hours before i exported to another program.   Its not the sum of the column that I need, its the sum of the employees time each day. 

Thanks,
Dean
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1560 Posts
  • 108 Reply Likes
Hi Dean,

Can we get on a quick call? I have your contact information. All I need is a convenient time to reach you.

Thanks,
Aashnee Kamboj