View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave
 
Posts: n/a
Default I'm new at this - having trouble with a formula



"SOX101010" wrote:


Dave... you could just make sure that all fileds are in time format and
then put the 5:00 in it's own cell (say A1). You formula would be...

F3 = F2+$A$1-E3

Hope this helps!!


--
SOX101010
------------------------------------------------------------------------
SOX101010's Profile: http://www.excelforum.com/member.php...o&userid=30205
View this thread: http://www.excelforum.com/showthread...hreadid=498866

Thanks to both of you - it works.