Formula for capturing old time and new time in a summary sheet

[aparnawangu]

Hi Friends,

I have two sheets in a workbook named old data and another new data.What I am trying to do is I have a summary sheet in which I am trying to capture the Customer,Project,Tasks and then the old spent time and the modified(new spend time)

I have two data sheets W1 & W2 which contains the data.Please guide which formula will work for this requirement.

Attaching sample file for reference.

Regards
Aps

[sandy666]

attached file doesn't contain W1 and W1.

[aparnawangu]

Friends,

Pls tell me the formula I cant paste the data due to sensitivity issue.

[sandy666]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.