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

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.

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

In F3

=F2+"5:00"-E3

Copy down as needed.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=498866

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

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

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.