Im having a problem in google sheets. I want to sum 2 columns the time that a driver is driving without the stops. So im using this formula to do it:

G7 is 10:20 value and H6 is 10:00.

But I want to do it in all the lines, but when I use the same formula:

I get this value:

Any idea how can I ignore the zero values that are making my database giving me wrong values when in this example the result I want is 00:40. The time driving without the unloads?

CodePudding user response：

use:

=TEXT(SUMPRODUCT(IF(G7:G20="";;G7:G20-H6:H19)); "[h]:mm")