I am working with vessels and calculating the scheduled time vs. the arrival time. Often it is more than 24 hours. When I calculate scheduled to arrived, I do the following:
Scheduled: 04/05/15 03:00 Arrived: 04/08/15 17:52
Scheduled date and time in cell A1, Arrived date and time in cell H1. Formula =(h1-A1)*24/24, then customized as [h]:mm format. This works perfect.
However, sometimes the vessel arrives before it was scheduled and the calculation does not work.
I tried to do an if statement, but excel is not recognizing the "(" as part of the first argument. I want the if statement to say,
Argument =if(h1-a1)*24/24<0 if that is "true", then 0, if that is false than (h1-a1)*24/24. How do I make excel understand the argument already includes a "("?