6 Replies Latest reply: Jul 6, 2017 12:09 PM by EZEQUIEL CONTE

# 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

• ###### Re: Minute "interval" problem

May be try this

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

• ###### Re: Minute "interval" problem

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

regards

• ###### Re: Minute "interval" problem

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

• ###### 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

• ###### Re: Minute "interval" problem

For not considering the seconds floor both dates first

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

• ###### Re: Minute "interval" problem

This formula worked.
Thank you all!