Hi, One option would be =SUMPRODUCT(INT(A2:A6))+INT(SUMPRODUCT(MOD(A2:A6,1 ))/0.6)+MOD(SUMPRODUCT(MOD(A2:A6,1)),0.6)
Forum Rules
Bookmarks