Friday, February 17, 2012

DateDiff Formula

hiiiiiiiiii
how to make formula for to get minute (time) use datediff
thanks...
jebatSooooooooo,

You want the number of minutes between two DateTimes using the DateDiff function.
I assume you've looked at the help on DateDiff? ...it's all there...|||yeah, it's pretty straightforward. i did the following to calculate the difference in days, i think for minutes you just have to use "n" instead of "d":

formula = DateDiff("d", Date1, Date2)

No comments:

Post a Comment