If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Calculating Time
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. |
#3
|
|||
|
|||
Calculating Time
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 |
Thread Tools | |
Display Modes | |
|
|