Hey there everyone! I've come across something that I'm not sure how to handle actually and would like some input on it.
So my predicament is that i have a table set up that i input time of each tool in a machining program, and it then calculates the average and percentage and kicks out a graph based on that.
It works great however i have it set up for inputting time cumulatively, so then there's a column that then takes a time and subtracts it from the previous time to get the actual time in seconds that tool had taken. And id still like to have the option, but also have the option of just putting in the time individually in case i just time each tool by itself.
I know the easiest would be just to subtract the accumulative times myself and input them as individual times but i like having excel being able to break down the accumulative times for me.
So im wondering what the best way to handle this is? so that i could input times as either accumulative, or individually? And i want it so that i can just add/delete tools and times as needed for each operation i study.
I was thinking maybe a button that could switch from accumulative time mode, to individual time mode or something? but not sure how that would work, any input would be greatly appreciated!!
Here's what my table looks like for reference.
So my predicament is that i have a table set up that i input time of each tool in a machining program, and it then calculates the average and percentage and kicks out a graph based on that.
It works great however i have it set up for inputting time cumulatively, so then there's a column that then takes a time and subtracts it from the previous time to get the actual time in seconds that tool had taken. And id still like to have the option, but also have the option of just putting in the time individually in case i just time each tool by itself.
I know the easiest would be just to subtract the accumulative times myself and input them as individual times but i like having excel being able to break down the accumulative times for me.
So im wondering what the best way to handle this is? so that i could input times as either accumulative, or individually? And i want it so that i can just add/delete tools and times as needed for each operation i study.
I was thinking maybe a button that could switch from accumulative time mode, to individual time mode or something? but not sure how that would work, any input would be greatly appreciated!!
Here's what my table looks like for reference.