I tried to upload the file, but for some reason the forum won't let me. Anyway, in Cell D3, copy and this formula =TEXT(IF(OR(ISBLANK(A3),ISBLANK(B2)),"",A3-B2),"HH:MM") in E3 Copy and paste this formula and hit Ctrl + Shift + Enter to enter the array formula =SUM(--RIGHT(D3:D5,FIND(":",D3:D5)-1))