Results 1 to 6 of 6

Calculate percentage of work complete in hours

Threaded View

  1. 09-02-2015, 06:33 PM #1
    OceanBlue
    OceanBlue is offline
    Registered User
    Join Date
    02-09-2011
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    87

    Calculate percentage of work complete in hours

    How can I get the result to give me % of work complete, and once the remaining hours are Zero, how can the Work complete = 100%


    Cell C3 = 4 hrs
    Cell D3 = 1 hrs
    Cell E3 = %work complete ?

    Attached is my sample sheet
    Attached Files Attached Files
    Oceans Blue
    Reply With QuoteRegister To Reply
« 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. Calculate work hours between two dates/times, incl Sat (variable hours) & excl Pub Hols
    By JReacher in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-02-2013, 10:57 AM
  2. Calculate / Forecast Estimated Hours to Complete
    By mycon73 in forum Excel General
    Replies: 10
    Last Post: 11-09-2012, 08:17 AM
  3. A formula needed to calculate my work when it is 100% complete.
    By Vic78 in forum Excel General
    Replies: 5
    Last Post: 10-18-2010, 08:53 AM
  4. Formula Required to work out remaining days via percentage complete data input
    By Moggzy in forum Excel General
    Replies: 4
    Last Post: 09-08-2010, 11:17 AM
  5. 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
  6. Excel formula to calculate percentage for hours worked
    By KateC in forum Excel General
    Replies: 2
    Last Post: 11-27-2008, 11:56 AM

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