I would like to take time from "A1" and add 14 hours to it.

[Guest]

Good day,
What Have are as follows Departure time Arrival Time
Eta
18:00
06:20 06:00
The Eta I need to be done automaticly as Departure time plus 12 hours, and
secondly what I would like to get is if there are a Difference between
Arrival time and Eta the "time" difference.

 

[Bob Phillips]

=Departure_time+TIME(12,0,0)

=IF(ETA<>arrival_time,ETA-arrival_time,"")


--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)