View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
wisperc
 
Posts: n/a
Default Fun with Time values


=(NF7(M7+"1:0"),N7,0)

all i needed


--
wisperc
------------------------------------------------------------------------
wisperc's Profile: http://www.excelforum.com/member.php...o&userid=30123
View this thread: http://www.excelforum.com/showthread...hreadid=498118