Hello,
After converting large amounts of hours into working days I've noticed that the total working days that are displayed appears to be huge.
I've used the following formula in column J :
=QUOTIENT(I4,8)&" days "&((I4/8)-QUOTIENT(I4,8))*8&" hours"
=QUOTIENT(I6,8)&" days "&((I6/8)-QUOTIENT(I6,8))*8&" hours"
=QUOTIENT(I8,8)&" days "&((I8/8)-QUOTIENT(I8,8))*8&" hours"
=QUOTIENT(I10,8)&" days "&((I10/8)-QUOTIENT(I10,8))*8&" hours"
=QUOTIENT(I12,8)&" days "&((I12/8)-QUOTIENT(I12,8))*8&" hours"
After consulting a converting calculator I've saw some huge discrepancies between my results and theirs.
Attached you will find the excel table.
Bookmarks