24 Hour Time Chart

[DLC]

Hi,

Need help to create a horizontal line chart for different TASK mentioned in excel attached.
Need to create line chart where the starting point will be the start time n end time respectively.
Were Time should come in X axis and task should come in Y axis

Thanks in advance!!!

[DLC]

If not Line chart even stacked bar chart would do... Is there any possible solution to this query??

[Kaper]

Calculate difference end-start then prepare stacked bar with starts as first series an differences as second (see attachment).
Then do some formatting. Most important is to make series1 transparent. The rest is "housekeeping" with legend, axis titles, widths of bars, etc.

[DLC]

Thank you Kaper, This is more of a kind i m looking but when I change for Type C from 05:00 to 22:30 and 15:30 to 03:00 the chart goes in a negative direction is there any possible solution that i can set the X axis in 24 hour time format, which is it starts at 0:00 hours and ends at 24:00 hours..

[Kaper]

try:
=IF(B2>C2,C2-B2+1,C2-B2)
for time difference

[DLC]

Thank you Kaper!!!