[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Manufacturer[/TD]
[TD]Start[/TD]
[TD]Stop[/TD]
[TD]Total Days:[/TD]
[/TR]
[TR]
[TD]ITRAQ[/TD]
[TD]1/15/2019[/TD]
[TD]1/30/2019[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]2nd Phase[/TD]
[TD]Start [/TD]
[TD]Stop[/TD]
[TD]Total Days[/TD]
[/TR]
[TR]
[TD]CAT MEMO[/TD]
[TD]1/31/2019[/TD]
[TD]2/1/2019[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]HW/SW LIST[/TD]
[TD]""[/TD]
[TD]""[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Arch[/TD]
[TD]""[/TD]
[TD]""[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]PPSM[/TD]
[TD]""[/TD]
[TD]""[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MEMO[/TD]
[TD]""[/TD]
[TD]""[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Criteria[/TD]
[TD]""[/TD]
[TD]""[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]CERP#[/TD]
[TD][/TD]
[TD]2nd Phase Total Days:[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Total Days in Total[/TD]
[TD]21[/TD]
[/TR]
</tbody>[/TABLE]
This is the graph i'm stuck with and I'm trying to figure out how I can fix the total days for 2nd Phase Totals Days when the Start and Stop are all the same.
The problem is this adds up to 6 days when its really 1 day. However, if they are all different stop dates? What would the formula be to just grab the highest number out of those cells? Please help me!!!!
<tbody>[TR]
[TD]Manufacturer[/TD]
[TD]Start[/TD]
[TD]Stop[/TD]
[TD]Total Days:[/TD]
[/TR]
[TR]
[TD]ITRAQ[/TD]
[TD]1/15/2019[/TD]
[TD]1/30/2019[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]2nd Phase[/TD]
[TD]Start [/TD]
[TD]Stop[/TD]
[TD]Total Days[/TD]
[/TR]
[TR]
[TD]CAT MEMO[/TD]
[TD]1/31/2019[/TD]
[TD]2/1/2019[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]HW/SW LIST[/TD]
[TD]""[/TD]
[TD]""[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Arch[/TD]
[TD]""[/TD]
[TD]""[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]PPSM[/TD]
[TD]""[/TD]
[TD]""[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MEMO[/TD]
[TD]""[/TD]
[TD]""[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Criteria[/TD]
[TD]""[/TD]
[TD]""[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]CERP#[/TD]
[TD][/TD]
[TD]2nd Phase Total Days:[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Total Days in Total[/TD]
[TD]21[/TD]
[/TR]
</tbody>[/TABLE]
This is the graph i'm stuck with and I'm trying to figure out how I can fix the total days for 2nd Phase Totals Days when the Start and Stop are all the same.
The problem is this adds up to 6 days when its really 1 day. However, if they are all different stop dates? What would the formula be to just grab the highest number out of those cells? Please help me!!!!