ADDITION OF RUNNING HRS

[N AYYAPAN]

MY QUESTION IS AS FOLLOWS

A B C

1 EQUIPMENT NAME Flow hrs Cum-ve hrs[ 0.5 Hrs = 30 Min ]


2 PUMP A 24.00 480.00

3 PUMP B 24.00 480.00

4 PUMP C 24.00 480.00

5 PUMP D 24.00 480.00

6 PUMP E 24.00 480.00

ASSUME THE ABOVE DATA FOR THE DATE 20/11/2011(24*20DAYS=480.00)

NOW THE PUMP C RUN ONLY FOR 06 HRS ON 21/11/2011 SO THE CELL B4 WILL BE 06.00 FOR THE NEXT DATE

WHAT FORMULA I SHOULD USE IN CELL C4 SO THAT IT WILL ADD 06+480(VALUE OF 20/11/2011) AND GIVE RESULT AS 486

 

[fred]

my question is if you have 6 hours on nov 21st, wouldn't it be easy just to add the 6 in the formula? I'm assuming the column showing 24 above would change to "6" on row pump C.