Excel 2003. I have a spreadsheet containing the columns: Date, Time In, Time
Out. E.g.,
5/11/05 08:30 17:30
5/12/05 10:30 18:00

Is it possible to create a chart from this data with the following
characteristics? If so, how?

1. Dates down the left side.

2. Across the bottom, a time-of-day scale, beginning at 0800 and ending at
2200, with labels at one-hour intervals. I.e., 0800 0900 1000 1100 ...
2200

3. For each date, a horizontal bar which begins at the Time In value for
that date and ends at the Time Out value for that date.

Optionally:

4. Ability to enter multiple, non-contiguous Time In/Time Out pairs for a
given date, resulting in a "broken" bar for that date. E.g., 5/12/05 08:30
10:30 12:00 18:00

5. Display of a "total time in" value, in hours to one decimal position, to
the right of each bar. E.g., 8.5.

Thanks!