I don't get what you are asking. The first table looks very much what you
want, just a bit of formatting and stripping extraneous data would do it.
What and where are you doing any lookup up, and on what data?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

wrote in message
oups.com...
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