kapilkumar
New member
- Joined
- Feb 28, 2014
- Messages
- 2
- Reaction score
- 0
- Points
- 0
HI,
GOOD AFTERNOON EVERY ONE.
Hi, I have several incidents for 1 ATM ID with "Open Time" and "Close Time", i need to calculate the "Close Time" MINUS "Open Time"
and would need over lapping Incidents to be excluded while calculating.
Please find the sample below.
the last 3 Incidents are overlapping, eg ( 4,5,6). the calculated time should give zero.
Thanks and Regards
Kapilkumar.
GOOD AFTERNOON EVERY ONE.
Hi, I have several incidents for 1 ATM ID with "Open Time" and "Close Time", i need to calculate the "Close Time" MINUS "Open Time"
and would need over lapping Incidents to be excluded while calculating.
Please find the sample below.
the last 3 Incidents are overlapping, eg ( 4,5,6). the calculated time should give zero.
ATM ID | INCIDENT | Open Time | Close Time |
DDEL1780 | 1 | 2/26/2014 0:00 | 2/26/2014 9:02 |
DDEL1780 | 2 | 2/26/2014 13:41 | 2/26/2014 18:30 |
DDEL1780 | 3 | 2/26/2014 19:02 | 2/26/2014 23:59 |
DDEL1780 | 4 | 2/26/2014 19:11 | 2/26/2014 20:13 |
DDEL1780 | 5 | 2/26/2014 20:30 | 2/26/2014 23:59 |
DDEL1780 | 6 | 2/26/2014 20:30 | 2/26/2014 23:59 |
Thanks and Regards
Kapilkumar.