5 Replies Latest reply: Sep 26, 2014 9:36 AM by Emilien Petrini RSS

    Calculate hours between two dates

    Emilien Petrini

      Hi all,

       

      I want to know the numbers of hours between two dates.

       

      date_creation_hdate_prise_charge_h
      02/01/2014 23:1406/01/2014 09:37
      03/01/2014 16:2406/01/2014 09:35
      09/01/2014 03:3209/01/2014 09:56
      11/01/2014 01:0513/01/2014 10:11
      15/01/2014 07:1115/01/2014 09:44
      16/01/2014 16:4216/01/2014 18:11

       

      In my script :

       

      Main :

      SET TimeFormat='hh:mm';

      SET DateFormat='DD/MM/YYYY';

      SET TimestampFormat='DD/MM/YYYY hh:mm';

       

      At the loading of my data :

      Time(([Date clôture  ] - [Date de prise en charge  ]),'hh:mm') as tps_traitement

       

      This doesn't work, if somebody have an idea!

       

      Thanks.

       

      Emilien