Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

ezec1807
New Contributor III

Minute "interval" problem

Good! How are you?
I need to get the minute difference between two dates that are expressed in "DD / MM / YYYY hh: mm: ss". The difference that I want to obtain is contemplating only the minutes, that is, without considering the seconds.
Attached image.

interval.jpg


Thank you!


regards

1 Solution

Accepted Solutions
stigchel
Honored Contributor

Re: Minute "interval" problem

For not considering the seconds floor both dates first

Interval(Floor(date2,(1/1440))-Floor(date1,(1/1440)),'mm')

6 Replies

Re: Minute "interval" problem

May be try this

=Interval(Round(date2 - date1, 1/1440), 'mm')

ezec1807
New Contributor III

Re: Minute "interval" problem

Thank you Sunny! But the children round me. up. I do not get what I want.

ima.jpg

regards

Re: Minute "interval" problem

Why is second row 04? Can you explain why you need these outputs?

ezec1807
New Contributor III

Re: Minute "interval" problem

Because I'm interested only in the difference in minutes, without contemplating whether the seconds alter or not the minutes.


Thank you!


regards

stigchel
Honored Contributor

Re: Minute "interval" problem

For not considering the seconds floor both dates first

Interval(Floor(date2,(1/1440))-Floor(date1,(1/1440)),'mm')

ezec1807
New Contributor III

Re: Minute "interval" problem

This formula worked.
Thank you all!

Community Browser