If I also wanted to apply this to duty time, but where they may not be on and
off duty the same time can you advise how i would do that?

Duty On Duty Off
Leg 1 1300
Leg 2
Leg 3 2359

how can I have it look at the duty off column and keep looking till it finds
a time?

thanks

"T. Valko" wrote:

Try this:

=ROUND(MOD(arrive-depart,1)*24,2)

A1 = depart = 23:10
B1 = arrive = 1:55

=ROUND(MOD(B1-A1,1)*24,2)

Format as General or Number

--
Biff
Microsoft Excel MVP


"JB Bates" wrote in message
...
I am trying to calculate Flight Time - but the time enroute may or may not
cross over midnight.

IE:

Depart 23:10 Arrive 01:55 (looking for the result of 2.75 hours)
Depart 02:20 Arrive 02:45 (looking for the result of .42 hours)

Is there one formula I can use for all of column C to calculate time
regardless if it flies past midnight?

thanks