Calculating Time

  • Thread starter Thread starter Duane Emerson
  • Start date Start date
D

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.
 
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
 
Back
Top