How do i work out what each one has worked ?

B

BS Johnston

Hi , i have a major headache trying to calculate what my Technical crew are doing. I currently have them entering their data as follows:
Start times in Column A.....This is not always entered in order of tim
Finish times in Column
Tech initials in Column C,D,E &

When i add the durations of each of their jobs, filtered using their initials...the total is accumulative which is wrong as no one can be in two places at the same time

I would very much appreciate it if somone can help
 
Top