•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need to calculate % of involvment
Our take
To calculate the percentage of involvement for students in a project, you can use the following formula:
\[ \text{Percentage of Involvement} = \frac{\text{Max}(0, \text{D1} - \text{C1})}{\text{B1} - \text{A1}} \times 100 \]
This formula accounts for various scenarios, including students who joined late or left early. It ensures you measure only the time the student actively participated in relation to the project's total duration. By applying this formula, you can accurately assess each student
I need to ask for a quick formula from everyone.
I have 4 dates:
A1 = Date of Project Start
B1 = Date of Project End
C1 = Date Student joined Project
D1 = Date Student left Project.
I have to figure out what percentage of the project the student participated in.
For MOST students A1 = C1 and B1 = D1, but I need to figure out the percentages for students where this is not true. I have a formula for students who joined late but stayed to the end, but it gives junk results for ones who either joined at start and left early or ones who both joined late and left early.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#AI formula generation techniques#formula generator#rows.com#Excel compatibility#Excel alternatives#percentage#involvement#project start#project end#student joined#student left#formula#participation#dates#joined late#stayed to the end#joined at start