differences in time

[smithrd6]

I have two columns, one showing arrival time, the other departure time. To get the time span, I simply subtract departure from arrival. Problem is, should the departure time go beyond the same date, the data is incorrect. How do I account for the differences when the times exceed 24 hours?

thanks

 

[Jonmo1]

Try

=MOD(Arrival - Depart, 1)

 

[scottylad2]

Are there just times in your columns or dates as well? what would be your expected answer if Arrival was 26 hours after departure and the Dep time was 06:00 AM? without a date in the formula then your looking at an answer of 2 hours...

 

[Ifrite]

try (arrival-departure)*24

 

[smithrd6]

works...thanks