Excel Formula?-- if A1=11am, then D5=A1; if A1=12pm, then D10=A1
Here's my guess - you have a contract sheet with cells in row 3
corresponding to 11:00 am (cells go from D3 to L3). You also have row
11 corresponding to 12:00 pm (cells D11 to L11). You want to set up a
log sheet where cell D6 will contain either 11:00am or 12:00pm, and
depending on these values you want to bring up the contents of cells D
to L from the appropriate row of the contract sheet.
If this guess is accurate, then enter this in cell D7:
=IF(HOUR($D6)=11,contract!D3,contract!D11)
then copy this formula across to E7:L7
Hope this wild guess works for you.
Pete
|