Working Hours and Points System for Task Completion

Deva_b · 2024-10-23T12:19:17.809Z

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!

Thanks!

gustavosales0809 · 2024-11-21T02:04:00.814Z

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

system · 2025-01-01T12:20:11.106Z

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