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 & delivery
and in hours & 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)

"john tyler" wrote in message
...
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 & delivery
and in hours & mintues if we where late or early

Hi,

You could try something like;

=IF(B1A1,TEXT(B1-A1,"h:mm")&" late",TEXT(A1-B1,"h:mm")&" early")

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"john tyler" wrote:

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 & delivery
and in hours & mintues if we where late or early