Calculating Hrs from 2 dates fields

[#1]

How do you calculate hrs between columns L minus K ?

please see attached file for the format. 

any help would be highly appreciated.

[#2]

here is what i came up with but its not working out:

vHrsMult

* sum({$<$(sMTD(Production)),[Submission Transaction Types]={'QUOTED'},[Received Via]={'BSS'}>}

  rangesum(

  [Assign Date]

  ,-[Received Date]))

/ Count({$<$(sMTD(Production)),[Submission Transaction Types]={'QUOTED'},[Received Via]={'BSS'}>} [Assign Date])

[maxgro]

this is the difference in hour between two dates

replace the dates with your fields

=

(

date#('2/13/2014 12:27', 'MM/DD/YYYY hh:mm') -

date#('2/12/2014 15:03', 'MM/DD/YYYY hh:mm')

) * 24

[#4]

how would you change this formula?

Where 'Assign Date' = L and 'Received Date' =K

vHrsMult

* sum({$<$(sMTD(Production)),[Submission Transaction Types]={'QUOTED'},[Received Via]={'BSS'}>}

  rangesum(

  [Assign Date]

  ,-[Received Date]))

/ Count({$<$(sMTD(Production)),[Submission Transaction Types]={'QUOTED'},[Received Via]={'BSS'}>} [Assign Date])

[MarcoWedel · Accepted solution]

Hi,

one solution might be to create a seperate interval field to calculate with:

LOAD *,
    Interval([Assign Date]-[Received Date]) as Interval
FROM [http://community.qlik.com/servlet/JiveServlet/download/635003-132397/Example.txt] (txt, unicode, embedded labels, delimiter is '\t', msq);

hope this helps

regards

Marco

[#6]

but how to implement "interval" into this :

vHrsMult

* sum({$<$(sMTD(Production)),[Submission Transaction Types]={'QUOTED'},[Received Via]={'BSS'}>}

  rangesum(

  [Assign Date]

  ,-[Received Date]))

/ Count({$<$(sMTD(Production)),[Submission Transaction Types]={'QUOTED'},[Received Via]={'BSS'}>} [Assign Date])

Calculating Hrs from 2 dates fields

[#7]

anyone?

[villegasi03]

I am sorry I a little confused. Just to be clear. You are asking how to get the difference of time between two values from two columns right? Sorry I am going to simplify this so its clear in this example,

row 1 column 1 = " your first timestamp "

row 1 column 2 = " your second timestamp "

and you need the difference between the two in hours?