+ Reply to Thread
Results 1 to 4 of 4

IF(OR statement to calculate percentage of hours for daily, weekly, or monthly tasks

  1. #1
    Registered User
    Join Date
    04-09-2015
    Location
    Southeast Michigan
    MS-Off Ver
    2010
    Posts
    8

    IF(OR statement to calculate percentage of hours for daily, weekly, or monthly tasks

    Hello All,

    There were several solutions posted that were close to answering my question, but I did not find one that I thought I could alter to fit my specific request.
    I am trying to write one If statement that will calculate [column 4] the percentage based on user input data [in columns 3 and 5] of number of hours, and frequency.
    The worksheet assumes the following: 8 hours= 1 work day; 40 hours = 1 work week; 40 hours per week x 52 weeks per year / 12 months per year = 173.33 average monthly hours; and 2080 hours = work year.


    1 2 3 4 5
    A Task # Task Description # Hours Percentage Frequency [daily/wkly/monthly]
    B 1. Typing 4 50% Daily
    C
    D
    E

    Some tasks I complete on a daily basis.
    Some tasks I complete on a weekly basis.
    Some tasks I complete on a monthly basis.
    A1= Task Number
    A2= Task Description
    A3= User Input for number of hours (which can be per day, week, or month)
    A4= Answer cell [based on value entered in C1 and percentage calculated based on E1 [either Daily, Weekly, Monthly]. This assumes an 8 hour working day; 40 hour week; 2080 hours per year.
    A5= Text field of Frequency of task [daily, weekly, monthly]

    For example, If I type documents on a daily basis for 4 hours per day, my percentage would equal 50%; 4 hours per week would equal 10%; and 4 hours per month would equal [2.3%]

    I thought it might look something like: =IF(OR(E5="Daily",100/12.5*C5,""),(E5="Weekly",100/2.5*C5,""),(E5="Monthly",100/(2080/12)*C5,"") but am sure I am missing something...

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: IF(OR statement to calculate percentage of hours for daily, weekly, or monthly tasks

    Hi,
    Welcome to the forum!!

    Check attached

    Hope that helps!!
    Attached Files Attached Files
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  3. #3
    Registered User
    Join Date
    04-09-2015
    Location
    Southeast Michigan
    MS-Off Ver
    2010
    Posts
    8

    Re: IF(OR statement to calculate percentage of hours for daily, weekly, or monthly tasks

    Wow! Works like a charm! Thanks x 1,000,000!

  4. #4
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: IF(OR statement to calculate percentage of hours for daily, weekly, or monthly tasks

    Glad to know that helped!!

    You can click on "Add Reputation" below my post to say thanks!!
    Also, if your query is resolved please mark the thread as "Solved" from the "Thread Tools" at the top of the page.

    Have a Great Day!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 01-11-2016, 11:15 PM
  2. how to calculate weekly and monthly percentage returns from daily figures
    By bensittingdown in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 10-15-2014, 05:02 PM
  3. Calculate daily hours but save as monthly and yearly hours each day
    By auzgts in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-17-2014, 06:14 AM
  4. Replies: 3
    Last Post: 10-01-2013, 05:05 AM
  5. How to see percentage of items received daily, weekly, monthly?
    By ConfusedCitizen in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-21-2013, 03:44 PM
  6. Calculate Totals weekly and Monthly from daily Figures
    By mfjanoo in forum Excel General
    Replies: 3
    Last Post: 03-05-2012, 03:06 PM
  7. Replies: 1
    Last Post: 07-11-2008, 05:57 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1