Using sumif between two columns with an additional criteria

[Luisdp]

I have a table with 4 Columns.

ID Name Start_Time Finish_Time
VSL1 Name1 15:00 18:00
VSL1 Name1 12:00 16:00
VSL2 Name2 05:00 15:00
VSL2 Name2 12:00 15:00

What I want to do is to get the total worked time of every ID.

For example, for VSL1 would be 18:00 - 12:00, and for VSL2 15:00 - 05:00.

I am struggling with this formula! Please HELP!!

 

[Luisdp]

Sorry guys, I think that I'm not explaning myself very well.

I don't have a list of individual IDs. This is a table that grows every day and the list of IDs gets bigger and bigger. Just imagine adding ID by ID in my list just in order to get all the summary.

The idea of the formula is to go trough the array checking the IDs and when they match it should SUM only the MAX value for the Finish Time and the MIN value for the Start Time.

This is why I came to you cause I know that you can help me with this tricky formulas.!!

do you a list of individual IDs or does it have to be pulled out from the data group. if you already have a list, it is easy otherwise it can ce tricky

 

[tybaltlives]

Both formulas presented do exactly what you want. Can you describe how you want to view the results? I can think of three options. One is a separate list of IDs (which you say you can't do). Two is single line where you type the ID number snd see the results you want. Three is another column (to the right of your data) that shows the count. Again, both formulas would work as presented for this option. You would just see multiple entries of the same time wherever the ID number shows up. But I think it would be possible to hide unwanted values to make the table look simpler.

But please let us know how you want to see the results.