=IF(D6=--"11:00:00",D3-L3,IF(D6=--"12:00:00",D11-L11,""))

is my guess

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"BrightEyes_PR" wrote in message
...
I need to create a log that goes hand in hand with this contract that I
have.
Both are in Excel. The thing is I don't know if the following is
possible
nor if it is how would I write the formula. Here it is:

If in the contract the cell D6 says 11:00am, then I need the rest of the
fill-in info that's in the contract to come out in the log in the 11:00am
row
(D3-L3). If in the contract the cell D6 says 12:00pm, then the rest of
the
fill-in info in the contract should come out in the 12:00pm row (D11-L11).