Evaluate digits within numbers

Example numbers:

21130 & 21065


I want to check each number if EITHER of the two conditions is true:

1. if the third digit from the right (the hundreth place) is greater than zero;

or

2. if the second digit from the right (the tens place) is >=6.



If either is true I want to add a particular number to the original number.
My example numbers meet questions 1 & 2, respectively.

Any help on this?

Thanks again!

Hey!

Try this...
=IF(OR((MID(B14,LEN(B14)-2,1)+0>0),(MID(B14,LEN(B14)-1,1)+0>=6)),B14+"Add the Number",FALSE)

umm... i tried the formula on B14... u'd have to replace that, and "add the number" is where u'll have to add wherever the number is and change False to wotever u wanna do if the condition doesnt match...

Hope this helps

Regards
Mohit

hey thanks. i didn't see that one coming, but looks good! now if i could find a way around VBA for doing loops....

Hi there,

As I indicated in the post, I cannot use the custom [h] settings. I'm looking for low-tech ways to add times.