Welcome to SPN

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

Sign Up Now!

DateAdd function using decimal minutes...

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

  1. BetoWing

    BetoWing
    Expand Collapse
    Guest

    -- I want to add two decimal minute values to a starting time and then round
    the result up to a whole minute. Example: 0800 + 2.25 min + 3.45 min =
    0806. Right now my minutes get rounded down to 0800 +2 +3 = 5. Any help
    would be appreciated.

    BobWingmeister
     
  2. Loading...


  3. BeruthialsCat@gmail.com

    BeruthialsCat@gmail.com
    Expand Collapse
    Guest

    BetoWing wrote:
    > -- I want to add two decimal minute values to a starting time and then round
    > the result up to a whole minute. Example: 0800 + 2.25 min + 3.45 min =
    > 0806. Right now my minutes get rounded down to 0800 +2 +3 = 5. Any help
    > would be appreciated.
    >
    > BobWingmeister


    Sure there are better ways but i use this in a query to get the result
    you want

    Expr1: IIf((([varA]+[varB])*60) Mod
    60=0,Format(DateAdd('s',(([varA]+[varB])*60),[varStartTime]),"Medium
    Time"),Format(DateAdd('n',(1+Int([varA]+[varB])),[varStartTime]),"Medium
    Time"))

    varA varB are ur 2 adding minutes and varStartTime where u started.

    HTH
     

Share This Page