DateAdd function using decimal minutes...

#1 (**permalink**) 28-Jul-2006, 08:15 AM

-- 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10757-dateadd-function-using-decimal-minutes.html

*

#2 (**permalink**) 28-Jul-2006, 08:15 AM

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 =
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10757
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10757
Time"),Format(DateAdd('n',(1+Int([varA]+[varB])),[varStartTime]),"Medium
Time"))

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

HTH