Formula for every 200hrs cycle

[Solved/Closed]
Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
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 reply

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Could you post some part of your sheet and than explain what exactly you want to do.