ctuna
02-08-2008, 05:36 PM
I am trying to keep track of hours on equipment to send it off for repair.
I have a column I enter a static date in when equipment goes out.
I hve another column I enter another static date in when Equipment comes in.
I calculate the number of days between the dates with this formula in another column. =H62-$I$62
Works fine.
I have another column I calculate the number of days X 20 giving me a number of hours using this formula =INT(20*((L62)))
Works fine.
The problem I have is next time the equipment goes out I enter a new static date and it throws all my numbers out of wack.
What I am trying to do is to stop my numbers from resetting and just keep totaling up.
In other words the first time the equipment goes out and comes in = 200 hrs, when I put the next date in it will not reset, but stay at 200 hrs.
The next time it comes in = 100 hrs. It will add it to the previous #, 200 hrs. = a total of 300 hrs.
Any Help would be greatly appreciated!!!!:banghead:
I have a column I enter a static date in when equipment goes out.
I hve another column I enter another static date in when Equipment comes in.
I calculate the number of days between the dates with this formula in another column. =H62-$I$62
Works fine.
I have another column I calculate the number of days X 20 giving me a number of hours using this formula =INT(20*((L62)))
Works fine.
The problem I have is next time the equipment goes out I enter a new static date and it throws all my numbers out of wack.
What I am trying to do is to stop my numbers from resetting and just keep totaling up.
In other words the first time the equipment goes out and comes in = 200 hrs, when I put the next date in it will not reset, but stay at 200 hrs.
The next time it comes in = 100 hrs. It will add it to the previous #, 200 hrs. = a total of 300 hrs.
Any Help would be greatly appreciated!!!!:banghead: