2 Replies Latest reply: Jan 19, 2012 7:52 AM by Anne Duffy RSS

    Timestamp subtraction

      Hi Guys,

       

      I am loading from excel workbook

       

      I have the following data

       

      Start Time     Start Date          End Time  End Date

         9:00:00     01/01/2012          10:00:00    02/01/2012

        10:00:00    01/01/2012          10:00:00     05/01/2012

       

      My Formats are as follows :

       

      SET TimeFormat='hh:mm:ss';

      SET DateFormat='DD/MM/YYYY';

      SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

       

       

      I wish to load add a field called Turnaround which id the dfferent in Hours and Minutes between the 2

       

      Start Time     Start Date          End Time  End Date             Turnaround

         9:00:00     01/01/2012          10:00:00    02/01/2012          25:00

        10:00:00    01/01/2012          10:30:00     05/01/2012         96:30

       

      I have tried a few different versions on the cript but all to no avail

       

      Can anyone advise please ?

       

      Thanks


      Anne