Sum

chadlaw32

New Member
Joined
Jul 29, 2014
Messages
46
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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

pbornemeier

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

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

chadlaw32

New Member
Joined
Jul 29, 2014
Messages
46
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,807
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,099,914
Messages
5,471,478
Members
406,764
Latest member
ExcelMaker007

This Week's Hot Topics

Top