Forum Discussion
Trouble with SUMIFS Function
I'm tracking to track runtimes of various components of a machine. On one sheet, I enter the start/stop times of the day and calculate the runtime of each day. On another sheet, I have all my parts. ...
tjgreene I believe it didn't stop working and has nothing to do with going into Aug. The Life is showing time in HH:MM:SS and you have lapped over to another day. If you was to see "Life" in terms of hours try multiplying by 24 and display it as a number or just change the format to number and it will show Life in terms of Days
It is also possible to use a custom format
[HH]:MM:SS
which will display the count of hours beyond 24, e.g.
34:14:30
