Published on Planning Planet (http://www.planningplanet.com)

Home > Discussion Forum > Formula for % duration complete

Formula for % duration complete

By Jithin Kambhikanam
Created 11 Aug 2023 - 10:00
Submitted by Jithin Kambhikanam on Fri, 2023-08-11 10:00

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

By logging in, inputting data or deciding to view any further of our pages you agree to be bound by our Forum Rules, our T&C's and also our Privacy Policy
© Planning Planet 2000-2024. Run by Project Controllers for Project Controllers.
Source URL: http://www.planningplanet.com/forums/planning-scheduling-programming-discussion/987972/formula-duration-complete

Links:
[1] http://www.planningplanet.com/forums/planning-scheduling-programming-discussion