How can write add hours with a date for the folloiwng case?
Supose today(30/04/2011) we are working from 7am to 3pm and tomorrow is a holiday and after tomorrow(2/05/2011) work starts at 7 and finish 5). if we get a repair work today and need 7 hours to finsih it, we have to add this 7 hours with the current date and time (let's say 10 am now) and it should display the finishing date and time. The remaining working hours need to added with the next work starting hours, if the next day is holiday (eg. Sunday), then the remaining hours should be added with Monday's starting time.
How can I achive it using sql stored procedure or c#?
Please give a sample or good links.