+ Reply to Thread
Results 1 to 4 of 4

Calculate Projects within 40 hour work week

  1. 09-16-2017, 07:36 PM #1
    Pearl19Lewis
    Pearl19Lewis is offline
    Registered User
    Join Date
    09-16-2017
    Location
    DC
    MS-Off Ver
    365
    Posts
    2

    Calculate Projects within 40 hour work week

    Hello, can someone please assist with creating a formula for calculating project hours in percentage, within 40 hour work week. Thank you very much.
    Reply With QuoteRegister To Reply
  2. 09-16-2017, 07:41 PM #2
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Calculate Projects within 40 hour work week

    Wouldn't it just be..

    =A1/B1

    A1 = Hours worked
    B1 = 40 Hours
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  3. 09-16-2017, 08:06 PM #3
    Pearl19Lewis
    Pearl19Lewis is offline
    Registered User
    Join Date
    09-16-2017
    Location
    DC
    MS-Off Ver
    365
    Posts
    2

    Re: Calculate Projects within 40 hour work week

    Cheers, knew I was over thinking it. Thanks Jeff for the very quick response.
    Reply With QuoteRegister To Reply
  4. 09-16-2017, 10:01 PM #4
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Calculate Projects within 40 hour work week

    I'm glad you have a working solution. Happy to help

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 54 hour work week with pivot table
    By tommygoesha in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-26-2016, 12:55 PM
  2. How to calculate total work hours for workers from week table?
    By Vlad_ in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-19-2016, 03:54 PM
  3. [SOLVED] Calculating Overtime Hours based on 40 hour work week
    By workforceissues in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-11-2015, 05:34 PM
  4. trying to get 12 hour time format work hours/shift, with total per week with days off
    By mishii in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2013, 05:45 PM
  5. Excel 2007 : Calculating sick hours out of a forty hour work week
    By Klaviad in forum Excel General
    Replies: 3
    Last Post: 07-11-2012, 12:37 PM
  6. calculate work hours between two dates of a work week - Sunday to Thursday.
    By azkhan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-24-2010, 06:21 AM
  7. Calculating a colmun to total a 40 hour work week
    By Harley mom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-20-2005, 03:45 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1