Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Minute diffrence between dates

Discussion in 'Information Technology' started by Domac, Jul 28, 2006.

  1. Domac

    Domac
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    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

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Domac" <dd@dd.cc> wrote in message
    news:OihhS%23MrGHA.3996@TK2MSFTNGP04.phx.gbl...
    >
    > 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.
     

Share This Page