individual component hrs

[sandy8445]

hi,


i have unit XYZ & this unit has more than 20 components. if in a day unit runs for 30 minutes i.e each 20 componets run for 30 minutes, and each components has some specific inspection after completion of certain hrs like 1000 hrs/500 hrs/100 hrs/200 hrs. i have to track the total hrs completed by individual component.

file attached for reference.

suggestions from experts will be appreciated .