Total Time Calculation

[Dnyan]

Hi,

I have a data and I want to calculate total time - date wise of individual handler.

For ex. To calculate total time for Avinash in data sheet
1. Name Column
2. Date Completed Column
3. Total Time Column
(Please check grey field data in attach excel file)
From this
Search total time for Avinash for particular date completed.

[Andrew-R]

The formula to return a number of minutes in column I of the data sheet is =(H3-F3)*60*24

Then in cell B2 of the Idle sheet you need the formula =SUMIF(Data!$G$3:$G$12,B1,Data!$I$3:$I$12) and you can copy this across. Although I don't see how you're going to make it work for multiple agents.

[Dnyan]

You are calculated sum of minutes for particular date.
However i want a calcalation for individual name wise and date wise.

For ex. Avinash total time taken for 3rd of august is 119. I want 119 as a answer.

You filter Avinash for date completed 3rd August and take a sum and the answer is 119.

Regards,
Dnyan

[Andrew-R]

Ok, I'm with you - are you really using Excel 2003? If you're using 2007 then we can do this easily with SUMIFS.

[Dnyan]

I am using 2003 however u can tell me both.

[Andrew-R]

OK, on the Idle sheet the formula to go in each cell is:

Please Login or Register  to view this content.

Should work in 2003.

[Dnyan]

Thank you very much it working great.

Many Many Thanks