Calculating minutes between days

[Dextah68]

I was having issues calculating the minutes between two dates and having the results returned as a whole number. Found this formula worked best:
=IF(I1<>0,(DAY(I1-H1)*60*24+HOUR(I1-H1)*60+(MINUTE(I1-H1))),0)

[Paul]

Hi Dextah, welcome to the forum.

You could also use just:

=(I1-H1)*1440

or this if you still wanted to check if I1 was 0:

=IF(I1<>0,(I1-H1)*1440,0)

[miut]

I was having issues calculating the minutes between two dates and having the results returned as a whole number. Found this formula worked best:
=IF(I1<>0,(DAY(I1-H1)*60*24+HOUR(I1-H1)*60+(MINUTE(I1-H1))),0)

Hi Dextah68,
My suggestion is: why don't you use DAYS360 funciton of excel. The syntax is DAYS360(Startday, endday).

End day may be today. In my example, to get the day today, i set the formulas: "=today" for endday
If my expalanation is not satified/ corrected to your point, you may see it as an example
Cheer,

[Paul]

Hi Miut,

This thread is two months old and has not had a response from the original author. I'm also not sure how the DAYS360 function would be used to calculate time in minutes (without additional functionality added to the formula), per the author's request. DAYS360 is not even an accurate date-counting function, let alone minute-counting.