Gant Chart with data spread past midnight

Hi, I am trying to build a gant chart for nightly batch process. The batch window is from 21:00 to 4:00
I created a spreadsheet with the following columns (A)Job name, (B)Start time, (C)end time (D)duration(=MOD(D1-C1,1)

I build the Gant Chart, with start time & duration columns but any jobs past midnight won't show. The only way I found so far is to add 1 to start time so it shows as 24:10:00 instead of 00:10:00. A job that start @ 01:06 will be seen as 25:06.

I am not sure if this is the best way since I now struggle with a job that start @ 23:15 is now showing as 47:15

Any hints would ba appreciated

Hi, I am not sure I understand your reply, if you meant to enter time in the format "mm/dd/yy hh:mm:ss"; that cannot be done since the sheet is populated by someone else (unless there's a formula for this) and I need to go to other spreadsheets weeks behind.
What I was thinking is something like in a new column: If start time is not between 21:00:00 and 23:59:59, add 1 to start time, so a job that start at 22:15 will be showned as is but a job that start at 02:15 will be showned as 26:15. Then I would report these values in the chart.
Would that make sense??

Hi, I don't have problems with calculating th etime after midnight in th espreadsheet itself, it is when I try to create the Gant Chart that the data past midnight do not show.
Like I said earlier, it will show only if i add 1 to the value of column B, but only if time is past midnight.
See my attached example
Any clues??

Thanks

Hi, that would work if there would be a way to replace the values in the Y axis by the name of the job in column A.
Is there??

Thanks

Thank you for your help and time
I finally find a way for it to looks like a gant chart, see attached example
Basically, I added another column (see now columnB)that calculate if time is less than the start of my batch process (21:00) then add 1 to the value
I now created my chart based on that column and the duration.