Forum Discussion
Moving scheduled work hours
v-yingjl
Hi, thanks for weighing in.
I'm aware that probably I didn't explain it very well.
1. Overdue -> I meant that if any work were scheduled before today (how many days elapsed don't really matter)
The point is if that work weren't done, it should be done asap, which means scheduled on today as a reminder.
2. Yes, I want to accumulate these hours.
Let me show a 2 simple examples.
1. Today is 24th April
In my basic model without any calculations or adjustments, I have scheduled below work hours.
- On 20th March 60 work hours were scheduled
- On 4th April 30 work hours were scheduled
- On 24th April 10 work hours were scheduled
These hours weren't done!
If these work hours would be done then they would disappear by my SQL database.
Now, in my desired model I want to sum these hours, which means that on 24th April(today) I should have 100 work hours.
2. Example about weekends. (future)
Today is 24th April
In my basic model without any calculations or adjustments, I have scheduled below work hours.
- On 8th May 20 works hours were scheduled
- On 9th May 10 works hours were scheduled (Saturday)
- On 10th May 30 works hours were scheduled (Sunday)
In my desired model should be 60 works hours on 8th May (before the weekend).
I hope this would help you understand my problem.