We help IT Professionals succeed at work.

Add total duration of the weeks

Billa7 used Ask the Experts™
I need Experts help to add additional function in the attached Sumproduct formula. Currently data from Column D  cell is (Detail sheet) individually subtract at column E. How to make sure the subtraction value is actually a total sum of total duration of the weeks. E.g. Cell E3 need to subtract based on total duration of cell D2 and D3 (34:00 + 24:00), same goes if we need to count result at cell E4, total duration of (D2:D4) need to subtract. Hope Experts could help to add this function.  


Open in new window

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®


Thanks a lot