topic Find the difference in hours between two timestamps? in QlikView

Find the difference in hours between two timestamps?

richnorris — Wed, 07 Jul 2010 15:14:33 GMT

Hi, I'm trying to find the difference of two timestamps using interval(a-b), only I don't fully understand the numbers involved. Could anyone help explain to me how timestamp works? Essentially I want to say,

vAge = interval(timestamp(now()) - B)

if vAge <= '8 hours' Then

do something

The touble I'm having is working out what '8 hours' should look like? I've not had much luck deciphering the number that a timestamp gets converted from / to, from what I gather 0.0007 = 1 minute? Any help would be much appreciated! Thanks.

Find the difference in hours between two timestamps?

richnorris — Wed, 07 Jul 2010 15:18:39 GMT

So, 8 hours seems to equate to 0.33334, but I only found that through trial and error and am still really non the wiser as to why I'm using this value. There must be a more straightforward way of checking the difference in hours between two times?

Find the difference in hours between two timestamps?

Miguel_Angel_Baeyens — Wed, 07 Jul 2010 15:30:42 GMT

Hello Rich,

That value is equivalent to say that 8 hours are a third of a day. Interval() is used when the resulting time is more than 24 hours, and want to be showed as hours:mins:secs. So I'm guessing you are looking something like (untested)

=interval(time('12:30', 'hh:mm') - time('03:54', 'hh:mm'), 'hh:mm')

will return something like '08:36'.

Hope that helps

Find the difference in hours between two timestamps?

Wed, 07 Jul 2010 18:55:26 GMT

The number that date arithmetic returns is in 'Days'. To convert days to hours, you divide multiply by 24.

To convert 8 hours into the number of days, for comparison purposes:

1 day / 24 hours = 0.0416 X 8 hours = 0.33 (repeating)

The same holds for minutes, seconds, years, etc. Just treat whole numbers as 'days', and convert.

So in your case, I would take the time that I want to compare (8 hours) and convert that using the formula, and then just compare that to your date calculation.

Find the difference in hours between two timestamps?

neetu_singh — Fri, 09 Jul 2010 12:32:54 GMT

Hi Ryan,

I have done this that how to calculate the difference between hours in two timestamps.

I m sending you the attachment. Please upload the test file and check it out. is this the what you required or not.

I have selected two date with timestamp and now, it will take starting hour and ending hour and calculate the difference between them.

I think this is something like that what you required.

Plz let me know its fruitful for u or not.

Thanks

Neetu Singh

Re: Find the difference in hours between two timestamps?

sumitjadhav — Fri, 28 Apr 2017 09:26:31 GMT

Hi neetu,

Can you please send the logic ,because of personal edition ,I cant open your Qlikview app.

Thank's & Regards,

Sumit Jadhav.