Search results

Dear Based on the above suggested code I tried but now the total time taken is not showing any output

Dear Friends, I am really in deep shit and need your help to fix error. Actually I am calculating difference between 2 date/time excluding working hours and weekends. Working hours (7:15 am until 2:30 pm), for example if user enter start time 22/06/2016 13:30 pm and end time is 23/06/2016...

Dear it is only calculating the days

Dear DCrake, you solution was excellent but I want to ask one question. the text boxes you have in database3 were unbound which cannot store the date/time in database. appreciate if you can support with this

I have a table with Start_Date and End_Date. I want to calculate total time taken between excluding weekends (Fri / Sat) How can we exclude weekends and calculate time only for working hours (7:15 am until 2:30 pm) for example task started at 20/06/2016 1:30 and completed on 21/06/2016...

see the attached sample database... surely you will know the complete requirement. thanks

Hi Minty - I need total time taken to handle a request excluding weekends and working hours

I saw the above mentioned link it is only calculating hours difference but my requirement is bit complex...

Dear Expert Friends, I would really appreciate if you guys can support me on the below. I have a database to manage the department request and each type of request has different turn-around-time (Circulars - 6 hours (360 min), Policy - (960 mins), Form (420 mins), Process (new - 600...

Thank you very much for your kind response.