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