Hi,
Im writing a small application to time software projects. When a developer logs a query, they have to specify the estimated time it will take in working hours.
I would like to state the estimated closing time, taking into account that the business works 09:00 - 17:00 Mon-Fri
Example 1
Query logged at 15:00 on 23/01/2006
Estimated time = 3:00
Estimated completion time 10:00 on 24/01/2006
Example 2
Query logged at 09:00 on friday 27/01/2006
Estimated time = 12:00
Estimated completion time 12:00 on Monday 30/01/2006
Much appreciated if anyone can help me.
