Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with time formats
I have a software called Avaya CMS Supervisor which is used in the BPO
industry to measure employees performance. I cannot add images to these groups hence I have uploaded it to my website. Please visit h++p://www40.brinkster.com/Maxlott/AgentStaffintRpt.htm If you click on "Click here to view the report pulled up by the software" you will see how the software shows the report. Click on "Click here to view the excel file" to download the excel file. This exel file has 3 sections. 1. Range A3:N18 shows how the report will be exported in excel if you export it in NORMAL format. 2. Range A22:N37 shows how the report will be exported in excel if you export it in SECONDS (time) format. 3. Range A41:L41 is the end result which I am trying to achieve. But not able to do so due to time formats. If you look at the picture, I have written comments in red color what time format I want for the respective columns. I DO NOT want % ACW and % of calls held which I have crossed with blue color. **What I want I want to export this report in excel and the end result (range A41:L41) will have vlookup formula that will lookup the Phone login IDs from the raw report which is exported and populate the relevant data. Please advise whether to use the NORMAL format or SECONDS format and how can I use vlookup to populate the data what I want. You can send me an email at sandip.dhamapurkar<atgmail<dotcom Thanks Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hot key for time? | New Users to Excel | |||
Hot key for time? | Excel Worksheet Functions | |||
Hot key for time? | Excel Discussion (Misc queries) | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Time and motion chart | Charts and Charting in Excel |