Is there a way to convert/display a given chunk of time (for example a
person's shift) into a bar graph/chart?

For example: If someone works 6am-2pm, I would like to have that shift
show up as a bar in a graph covering those hours.

I would ultimately like to enter a person's shift and have it display
somewhere else on the page or another sheet in a graph form to see
graphically if we are short in coverage somewhere.

Any suggestions/help????