help cumulative hrs

R

Ray

I work for a drilling contractor, we have to keep a running toal of hours on
motors. Need help to figure out how to set it up so excel will do it itself.

e6 = hours run day time
f7 = hours run night time
e8 = total daily hours
f9 = cumulative hours

Allready have =sum(e6,f7) to = total daily hours

f9 = 11576 total hours, how can I program it to add e8 to f9, and still keep
the total hours adding up?

We run the motors 24 hrs a day(usually). so if I put 12 hrs in e6, and 12
hrs in f7. the total on e8 shows 24 hrs. I would like the total hours to keep
adding up from the total daily hours. Wether it is 24 hrs, 13hrs, 2 hrs. Can
someone please help, and show me the formula I need. Thanks. Hope your not
confused now.
 
S

Sean Timmons

so, presuming e8 is your first data point, f9 is =e8.

Then, presuming e12 is your 2nd data point, f13 would be =f9+e12

Once there, you can copy the 2nd formula down ot the bottom.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top