All you need is to use the =ROUND function to round off your results to
fewer decimal places. 6 places should be sufficient since you only
want to measure to the nearest minute.
CELL A2 = 9:00
CELL B2 = 9:10
CELL C2 = ROUND(B2-A2,6)
--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile:
http://www.excelforum.com/member.php...o&userid=32763
View this thread:
http://www.excelforum.com/showthread...hreadid=557747