Need Help with Calculation of total hours with a positive output

Hi,

I formatted two columns to military time format with a third column calculating the total hrs in each respective row. My problem is that once the hours key in are after midnight, I get an incorrect negative output in the calculating cell.

e.g. A B C
1900 0200 -1700
NOTE: the total in C should be 7

I have attached a sample of my file. Any help will be greatly appreciated.

Hi,

If you "CERTAIN" your Adjusted Hours will never exceed 24, then try:

=IF(ISERROR((E2-D2)*24),"",IF(E2-D2<0,((E2+1)-D2)*24,(E2-D2)*24))

in cell F2 and autofill down.

Cheers,

I'd use this formula in D2 copied down and across

=TEXT(B2,"00\:00")+0

then in F2 copied down

MOD(E2-D2,1)*24