>I've been struggling with rounding time to the nearest 15. Any suggestions? I figured I need to convert the minutes to seconds first but can figure out the equation to round to the nearest 15 minutes.
>
>TIA
>Jeff


Here is another one, just for 15 min intervals:

LPARAMETERS ttDateTime as Datetime

LOCAL ltDateTime as Datetime, lnMinDT as Integer
lnMinDT		= MINUTE(ttDateTime)
lnMinDiff	= ICASE( BETWEEN(lnMinDT,0,14), 15-lnMinDT ;
	, BETWEEN(lnMinDT,15,29), 30-lnMinDT ;
	, BETWEEN(lnMinDT,30,44), 45-lnMinDT ;
	, 60-lnMinDT)
ltDateTime	= ttDateTime + lnMinDiff*60 - SEC(ttDateTime)

RETURN ltDateTime