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.
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.