View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JB Bates[_2_] JB Bates[_2_] is offline
external usenet poster
 
Posts: 36
Default Time Calculation

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