Stefan_sSoko
New Member
- Joined
- Feb 17, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- 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.
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.