Working Hours and Points System for Task Completion

Need help
1

Hi everyone,

I’m working on a project where I need to track the total working hours within business hours (9 AM to 5 PM), excluding holidays and weekends. For example, if someone starts working at 4 PM and continues the next day at 10 AM, the total should count 1 hour on the first day and 2 hours the next day, making it 3 hours.

I also want to assign points based on how quickly the work is completed:

  • If the work is completed in less than 3 hours = 3 points
  • If the work takes between 3 to 8 hours = 1 point
  • If the work takes more than 8 hours = 0 points
  • If the work takes more than 24 hours = -2 points

For example:

  • If someone completes the task in 2 hours, they would receive 3 points.
  • If someone completes the task in 6 hours, they would receive 1 point.
  • If it takes more than 8 hours, they get 0 points.
  • If the task extends beyond 24 hours, they would receive -2 points.

Is there a way to approach this? Additionally, how should I handle situations where work extends past 5 PM on a working day? Any suggestions would be really helpful! :slightly_smiling_face:

Thanks!

2

I didn’t understand why he earned one hour one day and two the next, was it the time he worked that day?
Maybe this is a language problem
Wouldn’t it be better to score based on % of the estimated time for the task to be completed?
example, if the expected time was 2 hours in 3 hours, he would not gain a point
now if the expected time is 5 hours from 7, you would no longer earn the points
Did you manage to find any solution? since 30 days have passed

3

This topic was automatically closed after 70 days. New replies are no longer allowed.