Forum Discussion

tjgreene's avatar
tjgreene
Copper Contributor
Aug 05, 2020

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. ...
Formulas and Functions
mathetes's avatar
mathetes
Gold Contributor
Aug 05, 2020

tjgreene 

 

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.

  • mtarler's avatar
    mtarler
    Silver Contributor
    Aug 05, 2020

    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

    • tjgreene's avatar
      tjgreene
      Copper Contributor
      Aug 05, 2020

      mtarler  Thank you that's exactly what the problem was!

      • PeterBartholomew1's avatar
        PeterBartholomew1
        Silver Contributor
        Aug 05, 2020

        tjgreene 

        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