Service hours

Stefan_sSoko

New Member
Joined
Feb 17, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I'm attempting to create a document in which each morning before the shift, an operator will input the "Hours until Service" figure into a cell and using this information a total hours counter will increase by the amount that the "hours until service" has decreased.

Now my issue is, I have a cell in which this is done and each time I reset the hours until service back to 1000 as this is the interval at which they are done, the total hours resets back to its original figure.

I'm using a formula where hours until service is filled in C6, in the cell D6 I'm using =SUM(1000-C6) to give me the difference between 1000 and what the new figure is. I then use this number to add onto the current total hours in cell J6 =SUM(J6+D6) to give me my final result of the actual total hours in cell K6.

How can I keep the "Machine total Hours" from resetting?

Hopefully I can get some help, I can always add additional information if required.

1613577209457.png
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,127,643
Messages
5,626,059
Members
416,159
Latest member
CheeseBurger5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top