Thank you in advance for any help you can provide.
Above is the code I am using to find the closest time checked to the check windows listed below that are being audited.
Once the closest time is found then I check the difference between the two.
All of the "Time When Checked" cells will contain a formula. It will either show a time or be blank but not empty. The cell will always have a formula in it.
I am receiving a #value error when the formula encounters the cells that have formulas in them but a value of "".
The data will always be listed left to right. The check times might not be in order of earliest to latest. And, any cells with no values will always be on the right side.
<tbody>
</tbody>
Code:
{=IF(B2="OK","",MIN(ABS(B3-INDEX($B$1:$K$1,0,MATCH(MIN(ABS(B3-$B$1:$K$1)),ABS(B3-$B$1:$K$1),0))),ABS(INDEX($B$1:$K$1,0,MATCH(MIN(ABS(B4-$B$1:$K$1)),ABS(B4-$B$1:$K$1),0))-B4)))}
Above is the code I am using to find the closest time checked to the check windows listed below that are being audited.
Once the closest time is found then I check the difference between the two.
All of the "Time When Checked" cells will contain a formula. It will either show a time or be blank but not empty. The cell will always have a formula in it.
I am receiving a #value error when the formula encounters the cells that have formulas in them but a value of "".
The data will always be listed left to right. The check times might not be in order of earliest to latest. And, any cells with no values will always be on the right side.
<tbody> </tbody> |
<tbody>
</tbody>