jhonatanbenami
Board Regular
- Joined
- Jun 22, 2016
- Messages
- 56
Here is my data:
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
i need to find the time it takes to deal with application ,
the conditions are like this:
if (G3-B3)<=90
then application time is the result of : application number End date - application number start date
but if
(G3-B3)>90
then the calculation should be the
<tbody>
</tbody>
<tbody>
</tbody>
A | B | C | D | E | F | G |
application number | application number start date | task name | ID | task start date | task end date | application number End date |
6256372 | 16/07/2014 | missing/false documents | 63298632 | 19/01/2016 | 19/01/2016 | 26/01/2016 |
6256372 | 16/07/2014 | cash request | 63298632 | 03/01/2016 | 20/01/2016 | 26/01/2016 |
6715072 | 08/01/2015 | missing/false documents | 314019381 | 28/10/2015 | 21/01/2016 | 25/01/2016 |
6867668 | 19/02/2015 | missing/false documents | 16534356 | 25/02/2016 | 29/02/2016 | 01/03/2016 |
6867668 | 19/02/2015 | waiting for missing documents | 16534356 | 19/07/2015 | 25/08/2015 | 01/03/2016 |
6867668 | 19/02/2015 | missing/false documents | 16534356 | 12/07/2015 | 19/07/2015 | 01/03/2016 |
6976458 | 22/03/2015 | cash request | 50649391 | 08/02/2016 | 09/02/2016 | 15/02/2016 |
7164340 | 11/05/2015 | waiting for missing documents | 57208340 | 11/05/2015 | 26/08/2015 | 03/01/2016 |
7259512 | 09/06/2015 | waiting for missing documents | 13195672 | 04/01/2016 | 21/02/2016 | 23/02/2016 |
7421034 | 04/08/2015 | waiting for missing documents | 24888638 | 04/08/2015 | 02/09/2015 | 11/01/2016 |
7483311 | 27/08/2015 | missing/false documents | 1754621 | 04/01/2016 | 05/01/2016 | 10/01/2016 |
7505991 | 06/09/2015 | missing/false documents | 17274630 | 05/01/2016 | 17/03/2016 | 12/04/2016 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
i need to find the time it takes to deal with application ,
the conditions are like this:
if (G3-B3)<=90
then application time is the result of : application number End date - application number start date
but if
(G3-B3)>90
then the calculation should be the
application number End date for task name "missing / false documents" or for task name " waiting for missing documents" ( i have to pick one of them according to the latest) minus
<tbody> </tbody> |
<tbody>
</tbody>
<tbody>
</tbody>