Sum

[chadlaw32]

I need to add time punches leaving out over lapping times
Columns
A time of punch
D Queue
E Agent Name
F action (clock in or clock out)
J total time between clock in and out
I need to add up the times in column J that match an agent name and times do not over lap

time	stamp	callid	queue	agent	action	reason			Time logged in
10/10/2019 09:17:37	1570717057	NONE	inet-comm	John Doe(W)	UNPAUSE				236.65
10/10/2019 13:14:16	1570731256	NONE	inet-comm	John Doe(W)	PAUSE
10/10/2019 14:13:13	1570734793	NONE	inet-comm	John Doe(H)	UNPAUSE				227.00
10/10/2019 18:00:13	1570748413	NONE	inet-comm	John Doe(H)	PAUSE
10/10/2019 06:00:29	1570705229	NONE	eagle-inet	Frank Clark	UNPAUSE				121.87
10/10/2019 08:02:21	1570712541	NONE	eagle-inet	Frank Clark	PAUSE
10/10/2019 06:00:31	1570705231	NONE	inet-comm	Frank Clark	UNPAUSE				121.27
10/10/2019 08:01:47	1570712507	NONE	inet-comm	Frank Clark	PAUSE
10/10/2019 08:02:19	1570712539	NONE	eagle-inet	Patrick Mahomes	UNPAUSE				237.80
10/10/2019 12:00:07	1570726807	NONE	eagle-inet	Patrick Mahomes	PAUSE
10/10/2019 13:03:00	1570730580	NONE	eagle-inet	Patrick Mahomes	UNPAUSE				202.57
10/10/2019 16:25:34	1570742734	NONE	eagle-inet	Patrick Mahomes	PAUSE
10/10/2019 16:37:11	1570743431	NONE	eagle-inet	Patrick Mahomes	UNPAUSE				24.53
10/10/2019 17:01:43	1570744903	NONE	eagle-inet	Patrick Mahomes	PAUSE
10/10/2019 17:06:57	1570745217	NONE	eagle-inet	Tyreek Hill(W)	UNPAUSE				235.00
10/10/2019 21:01:57	1570759317	NONE	eagle-inet	Tyreek Hill(W)	PAUSE
10/10/2019 18:02:55	1570748575	NONE	inet-comm	Tyreek Hill(W)	UNPAUSE				175.98
10/10/2019 20:58:54	1570759134	NONE	inet-comm	Tyreek Hill(W)	PAUSE
10/10/2019 09:00:15	1570716015	NONE	eagle-inet	Tyreek Hill(H)	UNPAUSE				239.27
10/10/2019 12:59:31	1570730371	NONE	eagle-inet	Tyreek Hill(H)	PAUSE

<colgroup><col style="mso-width-source:userset;mso-width-alt:4644;width:95pt" width="127"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:1609;width:33pt" width="44"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:4937;width:101pt" width="135"> <col style="mso-width-source:userset;mso-width-alt:2560;width:53pt" width="70"> <col style="mso-width-source:userset;mso-width-alt:1682;width:35pt" width="46"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3364;width:69pt" width="92"> </colgroup><tbody>
</tbody>

 

[pbornemeier]

Re: Sum help

Please provide an example of each type of overlapping times.

 

[chadlaw32]

Re: Sum help

this is from the table above look at the first column the times over lap

10/10/2019 17:06:57	1570745217	NONE	eagle-inet	Tyreek Hill(W)	UNPAUSE				235.00
10/10/2019 21:01:57	1570759317	NONE	eagle-inet	Tyreek Hill(W)	PAUSE
10/10/2019 18:02:55	1570748575	NONE	inet-comm	Tyreek Hill(W)	UNPAUSE				175.98
10/10/2019 20:58:54	1570759134	NONE	inet-comm	Tyreek Hill(W)	PAUSE

<tbody>
</tbody>

 

[pbornemeier]

Is there any chance of getting something like:

10/10/2019 17:06:57 1570745217 NONE eagle-inet Tyreek Hill(W) UNPAUSE
10/10/2019 18:02:55 1570748575 NONE inet-comm Tyreek Hill(W) UNPAUSE
10/10/2019 20:58:54 1570759134 NONE inet-comm Tyreek Hill(W) PAUSE
10/10/2019 21:01:57 1570759317 NONE eagle-inet Tyreek Hill(W) PAUSE