vibinvenugopal
New Member
- Joined
- Jul 20, 2015
- Messages
- 9
There are multiple initiate and close operation for each name, I wanted to calculate the total time (close time - Initial time ) for each person.
[TABLE="width: 547"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Operation[/TD]
[TD]Time[/TD]
[TD]Total Time[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Initiate[/TD]
[TD]08/10/2015 10.00 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Start[/TD]
[TD]08/10/2015 10.00 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Close[/TD]
[TD]08/10/2015 10.00 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Initiate[/TD]
[TD]08/10/2015 09.00 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Start[/TD]
[TD]08/10/2015 09.05 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Close[/TD]
[TD]08/10/2015 10.15 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Initiate[/TD]
[TD]08/10/2015 11.00 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Start[/TD]
[TD]08/10/2015 11.10 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Close[/TD]
[TD]08/10/2015 11.20 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Initiate[/TD]
[TD]08/10/2015 12.00 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Start[/TD]
[TD]08/10/2015 12.10 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Close[/TD]
[TD]08/10/2015 12.40 PM[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 547"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Operation[/TD]
[TD]Time[/TD]
[TD]Total Time[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Initiate[/TD]
[TD]08/10/2015 10.00 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Start[/TD]
[TD]08/10/2015 10.00 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Close[/TD]
[TD]08/10/2015 10.00 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Initiate[/TD]
[TD]08/10/2015 09.00 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Start[/TD]
[TD]08/10/2015 09.05 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Close[/TD]
[TD]08/10/2015 10.15 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Initiate[/TD]
[TD]08/10/2015 11.00 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Start[/TD]
[TD]08/10/2015 11.10 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Close[/TD]
[TD]08/10/2015 11.20 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Initiate[/TD]
[TD]08/10/2015 12.00 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Start[/TD]
[TD]08/10/2015 12.10 PM[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Close[/TD]
[TD]08/10/2015 12.40 PM[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]