Hi

I have a date wise data in sheet 1 for a month. I need average of the
data in sheet 2 for date wise. Can anyone plz help me with the
formula? Thanks..


Below is the example of data which i have in sheet 1.

A B
1 Date Response
2 4-Jul-11 0:20:00
3 4-Jul-11 0:41:00
4 5-Jul-11 7:14:00
5 5-Jul-11 1:18:00
6 5-Jul-11 0:23:00
7 5-Jul-11 0:35:00
8 6-Jul-11 0:17:00
9 7-Jul-11 2:45:00


I need it in the sheet 2 as follows

A B
1 Date Response %
2 04-Jul-11 0:30:30
3 05-Jul-11 2:22:30
3 06-Jul-11 0:17:00




Sivaji