software

Just add them

=IF(A1 B1gt;C1 D1,quot;on timequot;,quot;latequot;)

as an example

Success can be calculated like

=COUNTIF(E:E,quot;on timequot;)/COUNTA(A:A)

and format as a percentage

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Ron Lieberquot; gt; wrote in message
...
gt;
gt; I apologize if this has been asked before, but a quick Google
gt; Groups search failed to turn it up, if so.
gt;
gt; My company needs to determine what percentage of deliveries
gt; we make are on time, or delivered late.
gt;
gt; I have a database that can make .csv reports, and we enter
gt; into each job the requested delivery time, and later the actual
gt; delivery time. Unfortunately the output is in two separate columns,
gt; one for the date, and another for the time. Well, four columns
gt; actually, two date ones and two time ones.
gt;
gt; What I want to do is combine each of the two date amp; time cells into a
gt; single cell that shows a 'datetime' value. That way, I could subtract
gt; one from the other (time requested with actual time we performed),
gt; and get the days and hours 'early' or 'late' delivery times, I hope.
gt;
gt; Can anyone advise if/how this can be done? I would also like to
gt; calculate the success/failure percentage at the bottom, of course.
gt;
gt; Thanks!
gt;
gt; RL
gt;