Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to calculate the minutes from two different dates I am using interval(date1-date2,'mm') is it correct or not other wise how to write the code to calculate the minutes
I don't understand. Do you want to calculate those dates in minutes? Or you want to extract the minutes from those dates?
interval should work, you could also just subtract one from the other and set the number format to interval and 'mm' when displaying
yes plz tell me correct or not
Your expr is correct
=interval(Date#('1/2/2014','M/D/YYYY')-Date#('1/1/2014','M/D/YYYY'),'mm')
date1 -date2 is a number
when date1 - date2 = 1 --> 1 day = 24*60 minutes
so I think you can just do the difference * number of minutes of a day
=(date1- date2)*(24*60)