Your problem is not formatting, it is data entry.

Always enter your times like:

05:00:00 and 14:00:00

The result should be 9:00:00 (9 hours, not 7, not 14)
--
Gary''s Student - gsnu200908


"da" wrote:

Hello
Everytime I type the time in hours, I get time and date in the cell. And I
can not calclulate the difference intime -From to. E.g. 0500 -1400 should
count 7.00 and I get the result 14.00. I used the time format from the menu.
Need Help, plz.
thanks

Hours Total
From To Hours