P
Paul
I am currently writing a Visit sheet for my staff to use. They have 4 areas
of work that they cover, referred to as B, E, L, P. They have to log the
date, Time of departure, Time arrived at a job and the respective mileages.
Each visit sheet may contain a number of visits for the various areas. There
may also be more than one set of visits carried out in that complete day.
The purpose of the data collection is to split the time & mileage spent
between the areas of work covered and charged back accordingly.
Following all the data being input by the staff
The Formula I am trying to create needs to:
Search the column containing the dates and add together all the mileage used
fields in respect of each the specific Discipline 'i.e. B, or E or L or P'
So in English....for example....
Date: Mileage leaving Office: Discipline: Mileage Arrived: Mileage
Returning Office
01/03/08: 012000 : E : 012025 : No Mileage as not returned to office (used
mileage = 25)
01/03/08: No Mileage : B : 012031 : No mileage to office (used mileage = 6)
01/03/08: No Mileage : E : 012045 : No Mileage to Office (used mileage = 14)
01/03/08: No Mileage : P : 012047 : 012051 (used mileage = 6)
03/03/08: 012075 : E : 012077 : 012079 (used mileage = 4)
The above is a rough sample of what data has been collected......
I need to select the whole of column A (which contains the date visited)
and search for all dates (for example) that contain 01/03/08 and add
together the figures that correspond to 'B' then a separate for 'E' etc.....
this filtering needs to result in:
Date B: E: L: P:
01/03/08 6 39 0 6
03/03/08 0 4 0 0
and so on for each date a visit was made in that month....
Hope this make sense
of work that they cover, referred to as B, E, L, P. They have to log the
date, Time of departure, Time arrived at a job and the respective mileages.
Each visit sheet may contain a number of visits for the various areas. There
may also be more than one set of visits carried out in that complete day.
The purpose of the data collection is to split the time & mileage spent
between the areas of work covered and charged back accordingly.
Following all the data being input by the staff
The Formula I am trying to create needs to:
Search the column containing the dates and add together all the mileage used
fields in respect of each the specific Discipline 'i.e. B, or E or L or P'
So in English....for example....
Date: Mileage leaving Office: Discipline: Mileage Arrived: Mileage
Returning Office
01/03/08: 012000 : E : 012025 : No Mileage as not returned to office (used
mileage = 25)
01/03/08: No Mileage : B : 012031 : No mileage to office (used mileage = 6)
01/03/08: No Mileage : E : 012045 : No Mileage to Office (used mileage = 14)
01/03/08: No Mileage : P : 012047 : 012051 (used mileage = 6)
03/03/08: 012075 : E : 012077 : 012079 (used mileage = 4)
The above is a rough sample of what data has been collected......
I need to select the whole of column A (which contains the date visited)
and search for all dates (for example) that contain 01/03/08 and add
together the figures that correspond to 'B' then a separate for 'E' etc.....
this filtering needs to result in:
Date B: E: L: P:
01/03/08 6 39 0 6
03/03/08 0 4 0 0
and so on for each date a visit was made in that month....
Hope this make sense