percentage of time

you are right that was the problem! and worked great
this arises another problem
the original data i copy paste from has minutes in wrong format and some but not all "total"time See attached
is there a formula to recognize these columns are for hours the other for minutes, or do i have to manually change each cell