I'm new at this - having trouble with a formula

[Dave]

I want F3 = F2 + 5:00 - E3. (The 5:00 is 5 hours and all the numbers are
hours and minutes). Maybe it goes without saying, but I would like all the
cells following F3 to have a similar formula. For example F4 = F3 + 5:00 -
E4. Thanks for any help.

 

[SteveG]

In F3

=F2+"5:00"-E3

Copy down as needed.

HTH

Steve

 

[SOX101010]

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!!

 

[Dave]

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?action=getinfo&userid=30205
View this thread: http://www.excelforum.com/showthread.php?threadid=498866

Thanks to both of you - it works.