chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
53
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. 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
timestampcallidqueueagentactionreasonTime logged in
10/10/2019 09:17:371570717057NONEinet-commJohn Doe(W)UNPAUSE236.65
10/10/2019 13:14:161570731256NONEinet-commJohn Doe(W)PAUSE
10/10/2019 14:13:131570734793NONEinet-commJohn Doe(H)UNPAUSE227.00
10/10/2019 18:00:131570748413NONEinet-commJohn Doe(H)PAUSE
10/10/2019 06:00:291570705229NONEeagle-inetFrank ClarkUNPAUSE121.87
10/10/2019 08:02:211570712541NONEeagle-inetFrank ClarkPAUSE
10/10/2019 06:00:311570705231NONEinet-commFrank ClarkUNPAUSE121.27
10/10/2019 08:01:471570712507NONEinet-commFrank ClarkPAUSE
10/10/2019 08:02:191570712539NONEeagle-inetPatrick MahomesUNPAUSE237.80
10/10/2019 12:00:071570726807NONEeagle-inetPatrick MahomesPAUSE
10/10/2019 13:03:001570730580NONEeagle-inetPatrick MahomesUNPAUSE202.57
10/10/2019 16:25:341570742734NONEeagle-inetPatrick MahomesPAUSE
10/10/2019 16:37:111570743431NONEeagle-inetPatrick MahomesUNPAUSE24.53
10/10/2019 17:01:431570744903NONEeagle-inetPatrick MahomesPAUSE
10/10/2019 17:06:571570745217NONEeagle-inetTyreek Hill(W)UNPAUSE235.00
10/10/2019 21:01:571570759317NONEeagle-inetTyreek Hill(W)PAUSE
10/10/2019 18:02:551570748575NONEinet-commTyreek Hill(W)UNPAUSE175.98
10/10/2019 20:58:541570759134NONEinet-commTyreek Hill(W)PAUSE
10/10/2019 09:00:151570716015NONEeagle-inetTyreek Hill(H)UNPAUSE239.27
10/10/2019 12:59:311570730371NONEeagle-inetTyreek 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>
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

pbornemeier

Well-known Member
Joined
May 24, 2005
Messages
3,848
Re: Sum help

Please provide an example of each type of overlapping times.
 
Last edited:

chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
53
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Re: Sum help

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

10/10/2019 17:06:571570745217NONEeagle-inetTyreek Hill(W)UNPAUSE235.00
10/10/2019 21:01:571570759317NONEeagle-inetTyreek Hill(W)PAUSE
10/10/2019 18:02:551570748575NONEinet-commTyreek Hill(W)UNPAUSE175.98
10/10/2019 20:58:541570759134NONEinet-commTyreek Hill(W)PAUSE

<tbody>
</tbody>
 

pbornemeier

Well-known Member
Joined
May 24, 2005
Messages
3,848
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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,110
Messages
5,545,993
Members
410,720
Latest member
SSL
Top