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
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,129,490
Messages
5,636,632
Members
416,932
Latest member
mm07

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