0 Replies Latest reply: Oct 27, 2016 8:12 PM by Josephinet Tedesco RSS

    time calcs

    Josephinet Tedesco

      Hi All

      I have an sql view only of the data which I import.

      the data comes as

      Date    

      14/07/2016

      Time1    

      4:12:00 PM

      Time2

      10:46:00 AM

       

      Expected Duration

      430 M

       

      I want to Time2 -Time1

      then I want to compare Time2 - Time1 (in Minutes) from the Expected Duration - so [Expected Duration] - (Time2 - Time1)

       

      I have used the following statements in load to delete the M in 430 M:

      Keepchar(ScheduledDuration,'1234567890') as SchedDurationMins,    this actually gives me the number 430

       

      To get the difference from Time2 - Time 1 I uses this when loaded

        (time(Time2) - time(Time)) as DurationDiff,   (however DurationDiff comes as a 0.226389 which I can then multiply by 24 *60  = 326

       

      and it worked!!!

       

      so just asking for helped worked - thank you all