Find difference between 2 times to get duration RRS feed

  • Question

  • I have a date and time stamp "2011-11-15 10:00:00" (StartDate) and "2011-11-15 11:00:00" (EndDate).


    I used substring-after(@StartDate, " ") to get "10:00:00" and the same for EndDate and placed them in StartTime and EndTime fields respectively.

    What I want to do now is get the difference between the 2 times. EndTime - StartTime = Hours

    I tried EndTime - StartTime but it returns NaN.


    Any ideas?

    Friday, November 4, 2011 4:13 PM