# Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

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.

Thank you!

regards

1 Solution

Accepted Solutions
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
MVP

## Re: Minute "interval" problem

May be try this

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

New Contributor III

## Re: Minute "interval" problem

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

regards

MVP

## Re: Minute "interval" problem

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

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

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')

New Contributor III

## Re: Minute "interval" problem

This formula worked.
Thank you all!