formatting time schedule

dannyd3212

New Member
Joined
Feb 15, 2005
Messages
6
I am having a problem with my labor usage schedule. I have the total amount of hours multiplied by the average employee wage. That comes out fine, but when I try to divide that by projected sales, I get a number that doesn't make any sense. Can you help?
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

cherria

Well-known Member
Joined
Nov 17, 2004
Messages
708
What do you mean a number that does not make sense?

What you will get is the amount paid to staff per dollar of sales which hopefully will be a small number if you want to make a profit.

Are you sure that is the result you want?
 

dannyd3212

New Member
Joined
Feb 15, 2005
Messages
6
cherria said:
What do you mean a number that does not make sense?

What you will get is the amount paid to staff per dollar of sales which hopefully will be a small number if you want to make a profit.

Are you sure that is the result you want?
I'm sorry, I needed the percentage of labor usage toward projected sales. The number i keep coming up with is .22 instead of .37. This is what I have:
A B C
1 8:00 AM 5:00 PM 9:00
2 8:00 AM 5:00 PM 9:00
3 Total Hours 18:00 =sum(c1:c2)
4 Average empl. wage 7.01
5 Amount Paid 126:18 =sum(c3*7.01)
6 projected sales 1382.51
7 Labor % .05 =sum(c5/c6)
I need the .05 to be .09.
 

dannyd3212

New Member
Joined
Feb 15, 2005
Messages
6
dannyd3212 said:
cherria said:
What do you mean a number that does not make sense?

What you will get is the amount paid to staff per dollar of sales which hopefully will be a small number if you want to make a profit.

Are you sure that is the result you want?
I'm sorry, I needed the percentage of labor usage toward projected sales. The number i keep coming up with is .22 instead of .37. This is what I have:
A B C
1 8:00 AM 5:00 PM 9:00
2 8:00 AM 5:00 PM 9:00
3 Total Hours 18:00 =sum(c1:c2)
4 Average empl. wage 7.01
5 Amount Paid 126:18 =sum(c3*7.01)
6 projected sales 1382.51
7 Labor % .05 =sum(c5/c6)
I need the .05 to be .09.
sorry again please ignore the .22 and .37
 

cherria

Well-known Member
Joined
Nov 17, 2004
Messages
708

ADVERTISEMENT

Hmm!

tricky one that, it all looks ok until you realise that excel is treating your 9:00 hours as a time and not a date.

replace the forumla in C1 with

=hour(b1)-hour(a1)

and in C2 with

=hour(b2)-hour(a2)

and see how that works
 

dannyd3212

New Member
Joined
Feb 15, 2005
Messages
6
sorry cherria, that still didn't work. I think i confused you along with myself. I apologize for that. Thanks for your help anyway.

Danny
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
dannyd3212 said:
sorry cherria, that still didn't work. I think i confused you along with myself. I apologize for that. Thanks for your help anyway.

Danny

You'll need to convert the hours to a decimal (multiply by 24 and format the cell as a number) then multiply by the wages, then divide.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,385
Messages
5,601,331
Members
414,446
Latest member
CRAVIN

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top