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.

In F3

=F2+"5:00"-E3

Copy down as needed.

HTH

Steve

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" 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.