How to calculate total time-intervals that correspond to a specific criterion

greetings all


my data
--------------------------------------------------------------------
I have a series of decimal values which represent hours, these values correlate to a given fuel flow rate at that time instant.

I have grouped the fuel flow rates into 3 groups
(=IF(F4 > =2800,3,IF(AND(F4 > =570,F4 < 2800),2,IF(AND(F4 > =0,F4 < 570),1)))

this correlates the fuel flow rates with the number of engines used (1, 2 or 3 Engines) depending on the fuel flow rate value

During a given time span the number of engines used in the ship fluctuates (post continued after pic)
Capture.PNG
----------------------------------------------------------------


problem
----------------------------------------------------------------
how can I measure the total time interval of each group???
(i.e the total timespan where No. of Eng=1 or No. of Eng.=2 or No. of Eng=3)

what I attempted was =SUMIF(G7661:G22484,1,C7661:C22484), =SUMIF(G7661:G22484,2,C7661:C22484), =SUMIF(G7661:G22484,3,C7661:C22484)
but realised that just adds the time values together

I think I somehow need to subtract the last value when the group changes from 1 - > 2, 2 - >3, 3 - > 2, 2 - > 1 with the first.... but I really have no idea how to get around this
-----------------------------------------------------------------


please god someone help me lol

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

---

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

apologies mate first time posting, didn't really know how to phrase it in a concise manner...

also this isn't some sort of homework, this is part of my dissertation research, I have conducted this from start to finish; I've just gotten stuck here and need some guidance as you said...