I have built a gannt chat to track the taskts for the team and found severl overlapping tasks...how can i calculate both the # of overlapping tasks AND the time overlapped.
ie
Status NY Start Time NY End Time duration
Count 02/27/14 08:39:41 02/27/14 09:50:18 01:10
Ship 02/27/14 09:50:18 02/27/14 10:04:42 00:14
Box 02/27/14 10:00:42 02/27/14 10:58:18 00:57
Call 02/27/14 10:45:18 02/27/14 11:50:18 01:05
here the rep is making a call while he is boxing...so id liek to get the # of tasks that overlap (1), and the time (13 minutes)
any suggestions??
Bookmarks