software

if i have a delivery thats booked for 5:00pm but is delivered at 6:15pm how
can i show that is was delivered 1 hour 15min late,

Or could i show date and time of intended delivery
Actual date of time amp; delivery
and in hours amp; mintues if we where late or early=MAX(delivery_time-due_time,0)

and format as time

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;john tylerquot; gt; wrote in message
...
gt; if i have a delivery thats booked for 5:00pm but is delivered at 6:15pm
how
gt; can i show that is was delivered 1 hour 15min late,
gt;
gt; Or could i show date and time of intended delivery
gt; Actual date of time amp; delivery
gt; and in hours amp; mintues if we where late or early
gt;
Hi,

You could try something like;

=IF(B1gt;A1,TEXT(B1-A1,quot;h:mmquot;)amp;quot; latequot;,TEXT(A1-B1,quot;h:mmquot;)amp;quot; earlyquot;)

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Masterquot;john tylerquot; wrote:

gt; if i have a delivery thats booked for 5:00pm but is delivered at 6:15pm how
gt; can i show that is was delivered 1 hour 15min late,
gt;
gt; Or could i show date and time of intended delivery
gt; Actual date of time amp; delivery
gt; and in hours amp; mintues if we where late or early
gt;