Benfica4ever
New Member
- Joined
- Jan 21, 2023
- Messages
- 7
- Office Version
- 365
- 2010
- Platform
- Windows
Looking for assistance with Microsoft Excel
Daily I must run Payroll for my employees a task that can take quite a bit of time when performing payroll. Specially when you have to consolidate timecards to a system report.
Daily I pull a report which contains the following information:
Column H contains the “Employee names” which contains their in the following format
“firstname lastname_EmployeeNumber” example “John Smith_12345” “Jane Dow_45678”
Column J contains the “Date”
Column L contains the “Agent state” with things like AfterCallWork, CallConsult, CallDialing, CallInbound, CallInternal, CallonHold, CallOutbound, LoggedOut, NotReadyForNextCall and WaitForNextCall
Column N contains a “Reason” with things like 503, Break, Call Back, Chat, Coaching Session, Lunch, Specialist Time, SystemIssue, and Training,
Column P contains the “Start time” of the activity
Column R contains the “End time” of the activity
Column T contains the “Duration” of the activity in minutes
I want to be able to filter all the data by employee and then be able to detect the following exceptions:
Daily I must run Payroll for my employees a task that can take quite a bit of time when performing payroll. Specially when you have to consolidate timecards to a system report.
Daily I pull a report which contains the following information:
Column H contains the “Employee names” which contains their in the following format
“firstname lastname_EmployeeNumber” example “John Smith_12345” “Jane Dow_45678”
Column J contains the “Date”
Column L contains the “Agent state” with things like AfterCallWork, CallConsult, CallDialing, CallInbound, CallInternal, CallonHold, CallOutbound, LoggedOut, NotReadyForNextCall and WaitForNextCall
Column N contains a “Reason” with things like 503, Break, Call Back, Chat, Coaching Session, Lunch, Specialist Time, SystemIssue, and Training,
Column P contains the “Start time” of the activity
Column R contains the “End time” of the activity
Column T contains the “Duration” of the activity in minutes
I want to be able to filter all the data by employee and then be able to detect the following exceptions:
- On the first instance where Agent state “Logged Out” is found under a row of Column L “Agent state” for that specific employee and if Column N is “blank”:
- I want Excel to pull the End Time for this row and place it in the sentence below.
- I then want Excel to look at Column L and find the first-row occurrence below this row in order to find the first row with “WaitforNextCall” under column L and then be able pull the “Start Time” from the column P where this occurs and place in the sentence.
- Finally, I want Excel to write the following sentence automatically on Sheet 3 of the workbook on cell A1
- Can we please update “Employee_Name” schedule for “Date” to reflect systems down paid from “End_Time Column R” to “Start Time Column P”
- Amy time that a row contains the following information: Column L contains “NotReadyForNextCall” and Column N is “blank” for that specific employee’s row.
- I want Excel to pull the Start Time for this row and place it in the sentence below
- I then want Excel to look at Column L and find the first-row occurrence below this row in order to find the first row with “WaitforNextCall” under column L and then be able pull the “Start Time” from column P where this occurs and place in the sentence as the “End Time”
- I want Excel to write the following sentence by pulling the information from the report automatically and be given the option to select whether it is a “Systems Down Paid” or “Systems Down Unpaid” exception manually, to complete the sentence depending on the employee’s timecard punches information.
- Finally I want Excel to write the following sentence automatically on Sheet 3 of the workbook on on a subsequent line
- Can we please update “Employee_Name” schedule for “Date” to reflect “Systems down paid” or “Systems down unpaid” from “Start_Time Column P” to “End_Time”
- Amy time that a row contains the following information: Column L contains “NotReadyForNextCall” and Column N is “Coaching” for that specific employee’s row.
- I want Excel to pull the Start Time for this row and place it in the sentence below
- I then want Excel to look at Column L and find the first-row occurrence below this row in order to find the first row with “WaitforNextCall” under column L and then be able pull the “Start Time” from column P where this occurs and place in the sentence as the “End Time”
- I want the system to write the following sentence by pulling the information from the report automatically and be able to select whether it is a “Systems Down Paid” or Systems Down Unpaid” exception manually to complete the sentence depending on the employee’s timecard punches information.
- Can we please update “Employee_Name” schedule for “Date” to reflect “Systems down paid” from “Start_Time Column P” to “End_Time”
- Amy time that a row contains the following information: Column L contains “LoggedOut” and Column N is “blank” for that specific employee’s row.
- I want Excel to pull the Start Time for this row and place it in the sentence below
- I then want Excel to look at Column L and find the first-row occurrence below this row in order to find the first row with “WaitforNextCall” under column L and then be able pull the “Start Time” from column P where this occurs and place in the sentence as the “End Time”
- I want the system to write the following sentence by pulling the information from the report automatically and be able to select whether it is a “Systems Down Paid” or Systems Down Unpaid” exception manually to complete the sentence depending on the employee’s timecard punches information.
- Can we please update “Employee_Name” schedule for “Date” to reflect “Systems down paid” or “Systems down unpaid” from “Start_Time Column P” to “End_Time”
