View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CaptainQuattro CaptainQuattro is offline
external usenet poster
 
Posts: 1
Default Comparing Calculated Times


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