Gantt chart not calculating anymore

The formula in column G is returning negative times if the departure time (F) is less than the arrival time (D). Change the formula in G2 to this:

=F2-D2+(D2>F2)

which has the effect of adding 24 hours in cases like this (i.e. the arrival is the next day).

I also used Find & Replace on columns D and F to replace : with : just in case you had any text values in those columns which look like times.

Hope this helps.

Pete

Hi Pete_UK,

"Find & Replace on columns D and F to replace : with :" this did the magic :-).

Thanks a lot!

Kind Regards,

John

Well, that's good to hear.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete