add floating bar to time schedule

Hello, I would like to create an excel formula that would have a start time, end time, duration, then have a bar graph showing that time to the right. any help would be appreciated.

You haven't put the times of the lunch breaks(?) in...
If they're always the same 'distance' from the start time you should be able to add them fairly easily.

My solution is thus:
You need a stacked column (or stacked bar, in your case, but this is purely cosmetic). For this to work you need Excel to know the differences between times - not the actual times. I have written an expanded version of how this looks in the attached but you could condense it very easily - it's just to show the logic of the solution. This means you can say on a day which starts at 6:45, has an hour for lunch at 11:45 and finishes at 4:45 is:
Off->6:45
On for 5 hours
Off for an hour
On for 4 hours

When you stack these up you get the outline of what you're looking for.

Then all we need to do is right click the "before work starts" series and set the border and fill to none and sim. for the "lunch time" series.

See attached, I'm sure once you see how this works you'll be able to tweak it to your own taste.

HTH

works great, thank you very much.