Timeline (Gantt) chart showing both hour and date

SK Roy,

if you want the X axis to be a timeline, why not use dates as the axis in the first place. You need some formulas to convert the hour values into real time values, but it would be easy to show the dates at the bottom.

You could show the values inside the bars.

See attached.

cheers