DateAdd function using decimal minutes...

[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

 

[BeruthialsCat]

-- 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