If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Array formula
Hello Folks,
I am using the following array formula: {INDEX(C$2:C$8800,MATCH(1,IF($A$2:$A$88800=$Y2,IF( $S$2:$S$8800=$AA2,1)),0))} The formula returns a Date/Time and I would like to add 1 hour to the return. Thanks |
#2
|
|||
|
|||
Array formula
=Your_formula+(1/24)
format as date and time -- Regards, Peo Sjoblom "Sandy" wrote in message ... Hello Folks, I am using the following array formula: {INDEX(C$2:C$8800,MATCH(1,IF($A$2:$A$88800=$Y2,IF( $S$2:$S$8800=$AA2,1)),0))} The formula returns a Date/Time and I would like to add 1 hour to the return. Thanks |
#3
|
|||
|
|||
Array formula
Just add +1/24 to the end of what you have (don't forget to use
Ctrl+Shift+Enter to commit the new formula. Rick "Sandy" wrote in message ... Hello Folks, I am using the following array formula: {INDEX(C$2:C$8800,MATCH(1,IF($A$2:$A$88800=$Y2,IF( $S$2:$S$8800=$AA2,1)),0))} The formula returns a Date/Time and I would like to add 1 hour to the return. Thanks |
#4
|
|||
|
|||
Array formula
Try this (still array entered):
=INDEX(C$2:C$8800,MATCH(1,($A$2:$A$8800=$Y2)*($S$2 :$S$8800=$AA2),0))+TIME(1,0,0) -- Biff Microsoft Excel MVP "Sandy" wrote in message ... Hello Folks, I am using the following array formula: {INDEX(C$2:C$8800,MATCH(1,IF($A$2:$A$88800=$Y2,IF( $S$2:$S$8800=$AA2,1)),0))} The formula returns a Date/Time and I would like to add 1 hour to the return. Thanks |
Thread Tools | |
Display Modes | |
|
|