Hey all, first post here. First off, please don't crucify me for using a google sheet AS AN EXAMPLE, my work's internet policies prevents me from getting the data to you guys in any other convenient format that I know of. Of course I use Excel, so please use excel functions or else I'll be really confused.
So, the file below shows the start and end times for faults on a machine. Once the machine has a fault, our system is notified immediately and our system will also tell us when the fault ends (columns A & B). I could easily sum up these times, but I am interested in finding out the total cumulative time we run on Machine 1 vs Machine 2. I could go through and do it by hand as I've done here, but my sheet is already decently large (this is just a sample).
So to reiterate, I'm trying to find the percentage of time we run Machine 1 vs running Machine 2. This can be decently accurately obtained by finding the time between the last end times on the machines.
Thanks!
https://docs.google.com/spreadsheets/d/1ZdQNowqBVPR-jd-lBR0OCitOBNNJAVpciRL78mpBnIg/edit?usp=sharing
<tbody>
</tbody>
So, the file below shows the start and end times for faults on a machine. Once the machine has a fault, our system is notified immediately and our system will also tell us when the fault ends (columns A & B). I could easily sum up these times, but I am interested in finding out the total cumulative time we run on Machine 1 vs Machine 2. I could go through and do it by hand as I've done here, but my sheet is already decently large (this is just a sample).
So to reiterate, I'm trying to find the percentage of time we run Machine 1 vs running Machine 2. This can be decently accurately obtained by finding the time between the last end times on the machines.
Thanks!
https://docs.google.com/spreadsheets/d/1ZdQNowqBVPR-jd-lBR0OCitOBNNJAVpciRL78mpBnIg/edit?usp=sharing
<tbody>
</tbody>