Returning the first and last time entry entered

CJames305

New Member
Joined
Jun 11, 2019
Messages
1
Hi all- First of all thank you for taking the time to read my post. I'm new here so really looking forward to any help possible, please excuse me if its a bit confusing!

I'm running a payroll audit. I have the time entered in our time data system as well as the phone system which tracks when calls were made. I'm having a hard time with formatting the phone data so that I can show time in and time out from the time data system as well as 1st call and last call that was made in the phone system. Here's what my summary would entail below. I am able to pull the time entry data into summary, but haven't been able to figure out formatting for the phone stamp data as it has multiple entries per agent per day of all their calls. In theory I need to be able to show what was entered in their time system and compare it to their phone activity. So if they clocked out at 5:30pm but have calls after showing at 5:50pm, I need to be able to review those items.
[TABLE="width: 297"]
<tbody>[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]Time [/TD]
[TD]Entry Data[/TD]
[TD]Phone[/TD]
[TD]Stamp Data[/TD]
[/TR]
[TR]
[TD]Time In[/TD]
[TD]Time Out[/TD]
[TD]First Dial[/TD]
[TD]Last Dial[/TD]
[TD]Review?[/TD]
[/TR]
[TR]
[TD]9:00 AM[/TD]
[TD]5:00 PM[/TD]
[TD]9:05 AM[/TD]
[TD]5:30 PM[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]9:05 AM[/TD]
[TD]6:00 PM[/TD]
[TD]9:10 AM[/TD]
[TD]5:55 PM[/TD]
[TD]No[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

I have the following columns available on phone data
[TABLE="width: 731"]
<tbody>[TR]
[TD="class: xl64, width: 70"]Site[/TD]
[TD="class: xl64, width: 174"]Supervisor[/TD]
[TD="class: xl64, width: 174"]Agent[/TD]
[TD="class: xl64, width: 56"]Agent Id[/TD]
[TD="class: xl65, width: 101"]Date[/TD]
[TD="class: xl66, width: 101"]Time[/TD]
[TD="class: xl64, width: 55"]Duration[/TD]
[/TR]
</tbody>[/TABLE]

Should I add in a Unique ID column with Agent ID & Date? Or should I also include the time so its specific? I would like to be able to pull the first time entered for an agent and then the last time entered for an agent per day.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Forum statistics

Threads
1,223,893
Messages
6,175,242
Members
452,623
Latest member
russelllowellpercy

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