Minute diffrence between dates

[Domac]

Hi,


I have a field based on Now() function , so date and time are in field.

I want to get time diffrence in minutes, not in days wich I get with
expression DateTime1 - DateTime2.

Please , help.


Domagoj

 

[Allen Browne]

Use DateDiff() with N for miNutes. (M is for Month.)

Like this:
=DateDiff("n", [DateTime1], [DateTime2])

More info:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html