hi
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?
hi
Why not add the duration.
Now you have start
and 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 best solution.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.