Hi everyone - see an example of the type of data I have below.
I need an equation that will sum the number of hours between 2 dates for a specific project.
Project Date Hours
A 1/10/2019 8
A 1/2/2020 5
A 6/2/2019 8
B 3/2/2018 10
B 4/1/2018 5
B 1/20/2019 8
For example - the number of hours between 1/3/19-1/3/20 for Project A is 21 hours. The number of hours for project B between 3/1/18 through 6/1/18 is 15 hours. Is there an equation that can do this for me?
Bookmarks