6 Replies Latest reply: Jul 3, 2014 8:58 AM by Shane Spencer RSS

    calculate the number of hours between two dates

      Hello,

       

      i work on application that must return the number of hours spent in the resolution of a mantis bug.

      the trouble is that i can't just do the difference between two date, imagine that the person began at 11am on 02/02/2014 and ends at 11 am on 03/02/2014, it will return 24h instead of 7h of work (09h-12 am and 02h-06h pm), and also there is an other problem we must eliminate the public holidays and days off of the difference between two dates.

       

      if you have any solutions, do not hesitate to help me.

      thank you very much.

       

      best regards