Time Tracker

Originally Posted by pjoaquin

Hi preatygirl,

Try this:

=11-LOOKUP(B149,{0,40,80,120,160,200,240;0,1,2,3,4,5,6})

That sounds good Paul....

And sorry to the first replyer, I really don't have an example.

Other than the total amount of monitors calculates in cell B149 as soon as the number of hours is inputed, (8 hours = 11 monitors)

I have it deducting 1 monitor per 40 minutes, (it's all tracked in intervals of 10 minutes) so my problem is, at 50, 60, 70 minutes, it reverts back to 11 monitors, (instead of staying at 10) and so on.

So when I hit 80, it goes to 9 (as it should) but on 90, 100, 110 it reverts back to 11, until I get to 160. (every 40 mins)

Hope this makes better sense.

I will try the above formula Monday at work and see what happens, any other suggestions are much appreciated.

Thanks!