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. ...
It would be a lot easier to be helpful on the specifics if you would post either the SUMIF formula that you've written OR the actual workbook you're using. Both would be preferable.
I can only hypothesize otherwise--there's probably something in the way you've written the formula or the way the dates (and times?) are stored--that is causing your problem.
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
