help

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
total count and the users are not standard,it changes . i,m wanting to divide the total users dependingon number of hrs worked for a week. if 500 is total and 11 users , out of which 3 are working 26 hrs and others are working 40 hrs. how can they be divided as per working hrs? the lesser the hour the work the lesser the work or total they get.
thanks.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
Pedie

you have to give us a minute to work it out, see your other post

as a regular you know this you also know not to change the heading and repost..... just go back to the original and bump but give it a while
 

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
Thanks. Sorry was duplucated due to network error [thought didnt go through the first time but did...my apologies]:)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,699
Messages
5,833,206
Members
430,196
Latest member
rez5656

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