Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to calculate the percent of budget used according to hours worked
and pay rate. In order to calculate the hours worked i used the following formula: =IF(((C34-B34)*24)=5,C34-(B34+TIME(0,30,0)),C34-B34) on a seperate worksheet I used the formula: =Schedule!$D$34 for each day of the week and =SUM(I30,H30,G30,F30,E30,D30,C30) to add all of the hours worked within that week. I then used the simple formula of =J30*B30 to calulate the cost of the labor. And my question is..... I now need to figure the percentage of budget used per emolyee on a weekly basis. I have tried the formula =k30/c3 but I'm not getting the correct answer... For example: based on a $100,000 budget an employee worked 22:30 hours and is at a pay rate of $8.00 per hour. The total cost for labor is $180.00 but the formula is calculating the percent vs. budget to be 0.01% instead of 0.18% Please help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculating | New Users to Excel | |||
calculating | Excel Worksheet Functions | |||
Calculating Top 5 | Excel Worksheet Functions | |||
Calculating Help | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions |