chadlaw32
Board Regular
- Joined
- Jul 29, 2014
- Messages
- 84
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
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
<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>
[TD="width: 127"]time[/TD]
[TD="width: 77"]stamp[/TD]
[TD="width: 44"]callid[/TD]
[TD="width: 68"]queue[/TD]
[TD="width: 135"]agent[/TD]
[TD="width: 70"]action[/TD]
[TD="width: 46"]reason[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 92"]Time logged in[/TD]
[TD="class: xl64, align: right"]10/10/2019 09:17:37[/TD]
[TD="align: right"]1570717057[/TD]
[TD="class: xl63, align: right"]236.65[/TD]
[TD="class: xl64, align: right"]10/10/2019 13:14:16[/TD]
[TD="align: right"]1570731256[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 14:13:13[/TD]
[TD="align: right"]1570734793[/TD]
[TD="class: xl63, align: right"]227.00[/TD]
[TD="class: xl64, align: right"]10/10/2019 18:00:13[/TD]
[TD="align: right"]1570748413[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 06:00:29[/TD]
[TD="align: right"]1570705229[/TD]
[TD="class: xl63, align: right"]121.87[/TD]
[TD="class: xl64, align: right"]10/10/2019 08:02:21[/TD]
[TD="align: right"]1570712541[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 06:00:31[/TD]
[TD="align: right"]1570705231[/TD]
[TD="class: xl63, align: right"]121.27[/TD]
[TD="class: xl64, align: right"]10/10/2019 08:01:47[/TD]
[TD="align: right"]1570712507[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 08:02:19[/TD]
[TD="align: right"]1570712539[/TD]
[TD="class: xl63, align: right"]237.80[/TD]
[TD="class: xl64, align: right"]10/10/2019 12:00:07[/TD]
[TD="align: right"]1570726807[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 13:03:00[/TD]
[TD="align: right"]1570730580[/TD]
[TD="class: xl63, align: right"]202.57[/TD]
[TD="class: xl64, align: right"]10/10/2019 16:25:34[/TD]
[TD="align: right"]1570742734[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 16:37:11[/TD]
[TD="align: right"]1570743431[/TD]
[TD="class: xl63, align: right"]24.53[/TD]
[TD="class: xl64, align: right"]10/10/2019 17:01:43[/TD]
[TD="align: right"]1570744903[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 17:06:57[/TD]
[TD="align: right"]1570745217[/TD]
[TD="class: xl63, align: right"]235.00[/TD]
[TD="class: xl64, align: right"]10/10/2019 21:01:57[/TD]
[TD="align: right"]1570759317[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 18:02:55[/TD]
[TD="align: right"]1570748575[/TD]
[TD="class: xl63, align: right"]175.98[/TD]
[TD="class: xl64, align: right"]10/10/2019 20:58:54[/TD]
[TD="align: right"]1570759134[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 09:00:15[/TD]
[TD="align: right"]1570716015[/TD]
[TD="class: xl63, align: right"]239.27[/TD]
[TD="class: xl64, align: right"]10/10/2019 12:59:31[/TD]
[TD="align: right"]1570730371[/TD]
[TD="class: xl63"][/TD]
</tbody>
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
NONE | inet-comm | John Doe(W) | UNPAUSE | |||
NONE | inet-comm | John Doe(W) | PAUSE | |||
NONE | inet-comm | John Doe(H) | UNPAUSE | |||
NONE | inet-comm | John Doe(H) | PAUSE | |||
NONE | eagle-inet | Frank Clark | UNPAUSE | |||
NONE | eagle-inet | Frank Clark | PAUSE | |||
NONE | inet-comm | Frank Clark | UNPAUSE | |||
NONE | inet-comm | Frank Clark | PAUSE | |||
NONE | eagle-inet | Patrick Mahomes | UNPAUSE | |||
NONE | eagle-inet | Patrick Mahomes | PAUSE | |||
NONE | eagle-inet | Patrick Mahomes | UNPAUSE | |||
NONE | eagle-inet | Patrick Mahomes | PAUSE | |||
NONE | eagle-inet | Patrick Mahomes | UNPAUSE | |||
NONE | eagle-inet | Patrick Mahomes | PAUSE | |||
NONE | eagle-inet | Tyreek Hill(W) | UNPAUSE | |||
NONE | eagle-inet | Tyreek Hill(W) | PAUSE | |||
NONE | inet-comm | Tyreek Hill(W) | UNPAUSE | |||
NONE | inet-comm | Tyreek Hill(W) | PAUSE | |||
NONE | eagle-inet | Tyreek Hill(H) | UNPAUSE | |||
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>
[TD="width: 127"]time[/TD]
[TD="width: 77"]stamp[/TD]
[TD="width: 44"]callid[/TD]
[TD="width: 68"]queue[/TD]
[TD="width: 135"]agent[/TD]
[TD="width: 70"]action[/TD]
[TD="width: 46"]reason[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 92"]Time logged in[/TD]
[TD="class: xl64, align: right"]10/10/2019 09:17:37[/TD]
[TD="align: right"]1570717057[/TD]
[TD="class: xl63, align: right"]236.65[/TD]
[TD="class: xl64, align: right"]10/10/2019 13:14:16[/TD]
[TD="align: right"]1570731256[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 14:13:13[/TD]
[TD="align: right"]1570734793[/TD]
[TD="class: xl63, align: right"]227.00[/TD]
[TD="class: xl64, align: right"]10/10/2019 18:00:13[/TD]
[TD="align: right"]1570748413[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 06:00:29[/TD]
[TD="align: right"]1570705229[/TD]
[TD="class: xl63, align: right"]121.87[/TD]
[TD="class: xl64, align: right"]10/10/2019 08:02:21[/TD]
[TD="align: right"]1570712541[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 06:00:31[/TD]
[TD="align: right"]1570705231[/TD]
[TD="class: xl63, align: right"]121.27[/TD]
[TD="class: xl64, align: right"]10/10/2019 08:01:47[/TD]
[TD="align: right"]1570712507[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 08:02:19[/TD]
[TD="align: right"]1570712539[/TD]
[TD="class: xl63, align: right"]237.80[/TD]
[TD="class: xl64, align: right"]10/10/2019 12:00:07[/TD]
[TD="align: right"]1570726807[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 13:03:00[/TD]
[TD="align: right"]1570730580[/TD]
[TD="class: xl63, align: right"]202.57[/TD]
[TD="class: xl64, align: right"]10/10/2019 16:25:34[/TD]
[TD="align: right"]1570742734[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 16:37:11[/TD]
[TD="align: right"]1570743431[/TD]
[TD="class: xl63, align: right"]24.53[/TD]
[TD="class: xl64, align: right"]10/10/2019 17:01:43[/TD]
[TD="align: right"]1570744903[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 17:06:57[/TD]
[TD="align: right"]1570745217[/TD]
[TD="class: xl63, align: right"]235.00[/TD]
[TD="class: xl64, align: right"]10/10/2019 21:01:57[/TD]
[TD="align: right"]1570759317[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 18:02:55[/TD]
[TD="align: right"]1570748575[/TD]
[TD="class: xl63, align: right"]175.98[/TD]
[TD="class: xl64, align: right"]10/10/2019 20:58:54[/TD]
[TD="align: right"]1570759134[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl64, align: right"]10/10/2019 09:00:15[/TD]
[TD="align: right"]1570716015[/TD]
[TD="class: xl63, align: right"]239.27[/TD]
[TD="class: xl64, align: right"]10/10/2019 12:59:31[/TD]
[TD="align: right"]1570730371[/TD]
[TD="class: xl63"][/TD]
</tbody>