Formula for every 200hrs cycle

Solved/Closed
yuzreen - May 3, 2011 at 01:54 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - May 3, 2011 at 07:21 AM
Hello,

now i'm trying to do a schedule maintenance for one part.the hours for the parts will increase everyday.e.g today 240 hrs,tomorrow 256 hrs.so,let say the hours due for inspection is 400hrs.so I want it to indicates how many hours left.that mean 144 hours,but i want it to countinously did the same thing on the next cycle.e.g 412 hours.hours due on 400 hours and the formula indicates 188 hours.Please help me.



1 response

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
May 3, 2011 at 07:21 AM
Could you post some part of your sheet and than explain what exactly you want to do.
0