Datatellsall2
New Member
- Joined
- Jul 17, 2018
- Messages
- 23
Hi There,
I'm analyzing a large amount of time entry data (30,000+ rows). I'm trying to calculate the day a project started and ended for one person...in the example below I'm trying to solve for when the project started and ended for Amy (via a function).
<tbody>
</tbody>
Thanks!
M
I'm analyzing a large amount of time entry data (30,000+ rows). I'm trying to calculate the day a project started and ended for one person...in the example below I'm trying to solve for when the project started and ended for Amy (via a function).
Project # | Name of Person working on project | Date | Day of Entry | Project Start for Amy (day #) | Project End for Amy (day #) |
1 | John | 4/1/19 | 1 | ||
1 | Amy | 4/4/19 | 4 | 4 | |
1 | John | 4/5/19 | 5 | ||
1 | Amy | 4/6/19 | 6 | ||
1 | Amy | 4/7/19 | 7 | 7 | |
<tbody>
</tbody>
Thanks!
M