John Campbell wrote: > round(seconds / 3600) > e.g. > > ROUND(TIME_TO_SEC('00:39:38')/3600) ; Should have thought of converting to seconds... doh! Thanks John and Brent. - A. -- Allen Shaw slidePresenter (http://slides.sourceforge.net)