negative times

[Guest]

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

 

[Bob Phillips]

=MAX(delivery_time-due_time,0)

and format as time

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Hi,

You could try something like;

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

Regards,

Chris.