You haven't told us which formula, nor what values you have when you "don't
get a correct calculation".

Try =MOD(B1-A1,1)*24 and format as general or number, not as time.
--
David Biddulph

mailrail wrote:
When I use this formula, it works for anything PAST midnight but I
don't get a correct calculation if the time doesn't go past midnight.
Will it not work both ways?

"JB Bates" wrote:

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