date time calculations - elapsed time

I have been reading the posts here and have made great progress. Getting the correct elapsed time to display will either work for instances under 24 hours or orver, but I can't get both to happen with the same formula.

Currently using this:
=INT(b2-a2) & " days " & TEXT(MOD(b2-a2,1),"[h]:mm:ss")

I cannot change the date system to 1904, so I'm getting a negative number for the days. Additionally, for time that has elapsed that is less then 24 hours, the days value is still -1 (rather then 0). Time appears to be calculating fine. Time elapsed over 24 hours, the days seem to be correct, but a negative value.

Does anyone have a suggestion for getting the days to calculate properly? I have attached a sample of the data I'm using.

I think you have your Bs and Cs mixed up in your formula. Try:

=INT(B2-C2) & " days " & TEXT(MOD(B2-C2,1),"[h]:mm:ss")

Yep, that was it!

Thank you brokenbiscuits!