Calculating Time

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

--

Regards,

Peo Sjoblom


"Duane Emerson" wrote in message
...
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.

On Tue, 16 Sep 2003 05:30:51 -0700, "Duane Emerson"
wrote:

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.

In your example, you are working 25 hours (5*5) on the project. To get the
percent: =25/40 and format the result as percent.

If you are storing start and end times as Excel times, then the math is a bit
different. The SUM will be in Excel time which expresses time as a fraction of
a 24 hour day. So the percent would be =YourSumFormula*24/40 and format the
result as %.

If you want the SUM displayed correctly (it's not necessary to get the
percent), then format the SUM cell as [h]:mm. The brackets around the h
prevent it from "rolling over" every 24 hours.


--ron