this database structure above allows me to follow the execution time of tasks by a set of freelancers
is it really suitable?
if I want to add up the time spent by each freelancer I have to survey each date can be in vain?
Why not add the duration.
Now you have
end, so before you save them, calculate the duration and store it with the other two. so for each entry you will have:
When you want to see the total time spent, only add the
duration for each entry.
You could even save a list of just durations if that’s easier. Or, when adding a new time, add the duration to a running total for the user perhaps?
Depends on the use case as to a
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.