Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

Formula for % duration complete

In the Open Standard
Jithin KambhikanamMember for 15 years 6 months
Created
3
3
0

Hello All

Need your support in excel.

Need to calculate % complete based on duration consumed from dates with an IFS formula

The table

Start

Finish

1-Jul-23

12-Jul-23

15-Aug-23

30-Aug-23

15-Sep-23

10-Jul-23

24-Aug-23

0%

7%

80%

100%

100%

46

 

Duration Complete

3

37

46

46

 

Thanks

Jithin

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Rodel Marasigan ·
    #1

    Hi Jithin,the simple formula

    Hi Jithin,

    the simple formula is = (Date - Start + 1) / (Finish - Start + 1) 
    Say Column A= Start, Column B = Finish, Column C = Date ... and so on, then Row 1 & Row 2 

    =(C$1-$A$2+1)/($B$2-$A$2+1)

    Note: Assumption - date does not have time entry that is why it needs +1. If time is included on the entry (ex: 8:00 AM to 5:00 PM) therefore + 1 is not required)

    Report
  2. 0
    Rafael Davila ·
    #2

    Any such formula that misses

    Any such formula that misses to consider CPM calendars (work hours, iregular work days and resource availability ...) will be wrong and misleading.

    Report
  3. 0
    Jithin Kambhikanam ·
    #3

    Thanks Rodel, Rafael, I am

    Thanks Rodel, Rafael,

     

    I am looking for a formula to populate the below table ie when I pull the fosrula from D3 to H3 it automatially gives the % complete based on the dates in D2 to H2.

     

    So the Duration based progress % (C3-B3+1) and the % changes based on D2 to H2.

     

    Any thing on that ?

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?