calculating total hours between dates

I need to calculate time taken to fix a piece of equipment.

A1 B1
BREAK TIME FIX TIME
4/22/08 23:00 4/23/08 04:00

Should be 5 hours, but i can't find the formula to make it work.

Thanks, as always.

cc

It's just =B1-A1 and formatted as time.

it doesn't work if it's over 24 hours.
4/22/08 01:00 (break)
4/24/08 15:00 (fix)
the simple subtract formula is coming up 14:00

Thanks much, that was the missing link for me.

Now for the next step in this formula.

I have a formula to report a fix rate:
fixed within 12 hours / number of breaks

i need a countif that will find the number of breaks fixed within 12 hours but will not include the no value cells. (essentially anything in the column that is >00:01 and <=12:00

Thanks again,

cc

=B1 - A1 - SUM(breakRange)

That won't get it, i'll be more specific:

A1
00:00
00:00
01:15
14:00
02:00
12:00
18:00
00:00

The returned value in this example would be 3. (3 times greater than 00:00, <= 12:00)

Thanks

=SUMIF(A1:A8, "<=0.5") returns 15:15 (1:15 + 2:00 + 12:00)

=SUMIF(A1:A8, "<0.5") returns 3:15.

Right, but i need a count, not a sum. This column indicates the time it took to fix an airplane after a break, but each row is a flight, so there won't always be breaks, therefore fixes. I need to report on how many fixes were accomplished in under 12 hours.

I'm losing the bubble here ...

=COUNTIF(A1:A8, "<=0.5")

we're getting closer...

that countif doesn't exclude the 00:00. Is there a way to do something like this:

=COUNTIF(A1:A8, "<=0.5") AND ...>.01 so that it won't count the 00:00 values?

You can either use 2 COUNTIFS, i.e.

=COUNTIF(A1:A8, "<=0.5")-COUNTIF(A1:A8,0)

or SUMPRODUCT, i.e.

=SUMPRODUCT((A1:A8>0)*(A1:A8<=0.5))