=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