Skip to Content
0
Former Member
Mar 28, 2007 at 04:32 PM

Exclude duplicate or overlapping data when adding time fields

17 Views

Post Author: Mark O

CA Forum: Formula

I am using Crytsal Reports XI. I have a several rows of start times, end times and total minutes. I would like to get a total time but some of the times are duplicates or overlapping each other. These duplicates/overlaps are not errors; they need to be in the report. I just can't double count the time. I am seeking a result of 45 Total Min in the below example. Thanks.

Start Time

End Time

Total Min

2:45 PM

3:15 PM

30

3:00 PM

3:15 PM

15

3:00 PM

3:30 PM

30

75