Excel Roster/Schedule Ghant chart fix issue

Job ID: 31108784

Budget: $10 – $30 AUD

Require a fix or solution for a Roster/Schedule.

Roster with color Ghant chart, fill in the chart reflecting the shift time hours.

In a 24 hour period, there are 3 shift pay rates.
Total hours for period 06:00-18:00 =
Total hours for period 18:00-00:00 =
Total hours for period 00:00-06:00 =

We will supply the current spreadsheet file

We can not use VBA or Macros, due to our system restrictions.
Related categories: Excel Visual Basic for Apps