Simple Gantt duratiuon issue

Hi team   We are upgrading our IT and setting up a Gantt to report to the business.  Seems simple, using the free Gantt in BI. Set up a sheet with some dummy data.  Piece of cake, right?!   Ever...