Military Time Difference formula...Help!

Hi,

I'm stuck on how to get this is work out correctly.

I have two columns that contain military time.

depending on the entry, the first column may be larger than the second and in other scenarios it's vice versa..

e.g.

Column A = 24:00
Column B = 06:00

Eg. Midnight to 6am. e.g. diff of 6 hours

or

Column A = 10:00
Column B = 18:00

eg. 10am to 6pm. e.g. diff of 8 hours

I need to have a formula that checks to see if A is larger than B and then calculates the difference and then in the same formula if B is larger than A then calculates the difference, etc.

I was playing around with this.. =(B2-A2)*24 but that only works if column B is larger than A. Otherwise I end up with negative numbers, etc.

Is there not a forumula that allows you to have a true and false and rather than a static value, allow you to have two seperate formulas based upon the true and false condition??

not sure that will work....


basically I was thinking it should be like this...

if A1>A2 then (A1-A2) * 24, if A2>A1 then (A2-A1) * 24

But not sure how that would go into a Formula.

Not sure if this is what you mean but try
=((B1-A1)+(B1<A1))*24