I wanted to calculate the time difference for each person. Please see attached data.

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]
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
"I wanted to calculate the total time (close time - Initial time ) for each person."

Person A has TWO lots of times, what results are you expecting for this person?
What do you want your output to look like?
 
Upvote 0
Yes that's correct, in the first instance for person A the total time is 0 (closed time - initiate time) and in the second instance for the same day its 40min, so that total time (output) is 40 min. In case if the first instance the total time is 10 min, then we need to calculate 10+40 and provide an output as 50 min as output.
 
Upvote 0

Forum statistics

Threads
1,223,239
Messages
6,170,947
Members
452,368
Latest member
jayp2104

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top