Forum Discussion
Toggle Day Counter
TSawyer1226 So the only way to do this is with a macro. i created a sheet with checkboxes that can be clicked ON and OFF to signify the machine is ON or OFF. Each time it will log that time onto an ongoing list of ON and OFF times. I then have a table to calculate the total ON and total OFF times. Note that those total times are updated when a change triggers a new calculation so if the machine is presently OFF that formula updates the total OFF time based on the time right now. You can change the time format to be days instead (i.e. integer numbers would work to signify days). I am also attaching a drawing on how I added a 2nd rig so you can add the 3rd, 4th, etc...
Hope this helps you.
mtarler Hello Hello. I seriously hope you get paid to be this freaking good. I just tested it out over the last day and I believe this is it! (I am totally doing a happy dance right now lol). Thank you again for all your help, the changes you made look wonderful and they do what I need them to.
P.S I am glad you like the macros lol I am still a noob when it comes to that stuff but glad I was in the right ballpark.
TSawyer1226 You are very welcome and very happy it is helpful. No I/we are just volunteers here and this isn't even directly related to my real job (I use excel but just like you or anyone else in business. i.e. not a consultant). My payment is knowing I helped someone and seeing my Likes and Best Responses tick up 🙂