G
Guest
I have the following table:
Columns:
A B C D
Date From Date To
A2 B2
Date Unit Category Time
12/9/07 Wilts U/S 2:00
12/9/07 Wilts S 8:00
13/9/07 YAA S 9:00
15/9/07 YAA U/S 3:00
and so on.......
How can I filter the data so that when i enter two dates in cell A2 and B2,
it gives me the totals time under each unit and category between those dates
Columns:
A B C D
Date From Date To
A2 B2
Date Unit Category Time
12/9/07 Wilts U/S 2:00
12/9/07 Wilts S 8:00
13/9/07 YAA S 9:00
15/9/07 YAA U/S 3:00
and so on.......
How can I filter the data so that when i enter two dates in cell A2 and B2,
it gives me the totals time under each unit and category between those dates
11)*24