Array formula

[Sandy]

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

 

[Peo Sjoblom]

=Your_formula+(1/24)

format as date and time

--


Regards,


Peo Sjoblom

 

[Rick Rothstein \(MVP - VB\)]

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

 

[T. Valko]

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)