Incerc sa calculez data de finalizare a unui proiect adaugandu-se numarul de ore estimate de lucru, dar tinandu-se cont de nr de ore de lucru pe zi, de zilele de weekend si zilele libere.
Cod: Selectaţi tot
+---------------+--------------+-------+--------+
| workday start | workday stop | pause | result |
+---------------+--------------+-------+--------+
| 08:00 | 17:00 | 1:00 | 8:00 |
+---------------+--------------+-------+--------+
+------------------+-------+------------------+
| start | hours | end |
+------------------+-------+------------------+
| 01.01.2020 08:00 | 16 | 02.01.2020 17:00 |
+------------------+-------+------------------+