How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Ryan-CTech Your Own Question

Ryan-CTech
Ryan-CTech, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 524
Experience:  Expert VBA Programmer.
18042535
Type Your Microsoft Office Question Here...
Ryan-CTech is online now
A new question is answered every 9 seconds

I am trying to create a formula based on # XXXXX hours per week

This answer was rated:

I am trying to create a formula based on # XXXXX hours per week worked and personal time off earned for a year. For example a 37.5 hour work week gets 17 hours personal time off for entire year. However, I have figure out the number of hours for a 30 hours, 27 hours, 25 hours, and 20 hours would recieve. Anybody have any suggestions to this.

yegarboy :

This should help get you started :)

yegarboy :






































Work WeekYearly HoursHours Per Week EarnedPersonal Hours Earned
37.519500.3317
3015600.2613.5
2714040.2312.2
2513000.2211.3
2010400.179
yegarboy :

I arrived at this thru a percentage of 45% (45.3) to be exact.

yegarboy :

Please let me know if I can assist you further. Please dont Rate my answer until you are happy :)

Customer:

I hate to be obtuse; however, I am still not sure how you arrived at your answer. Can you give me the exact formula you used.

yegarboy :

I can do better than that :). Here is my Workbook with a table showing how i got my answers.

Customer:

Seeing it in the spreadsheet helps greatly. I thought I was going to lose my mind figuring this one out. Now that I see it, I feel a little stupid for not getting it sooner.

Customer:
Ryan-CTech and other Microsoft Office Specialists are ready to help you
Glad to of helped :)