Calculating Time

[Duane Emerson]

I'm trying to add & divide hours that exceed 24. Ex: I
work on a particular project 5 hours a day Mon - Fri. I
would like to total the hours, then divide by my 40 hours
worked to determine what % of time was spent on that
project. Thanx.

 

[Peo Sjoblom]

If the hours are entered as integers

=SUM(A1:A50)/40

format as percentage

if entered in excel time format

=SUM(A1:A50)/"40:00")

format as percentage