Time Format and Calculate difference in time

  • Thread starter Thread starter da
  • Start date Start date
D

da

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
 
Post what is in the cells and the formula you used, time is pretty
straightforward just subtract

=A1-B1

where B1 holds 05:00 and A1 holds 14:00 will return 9:00 and not 7:00

Of course if you use time you should tell Excel that you are using time and
use : as a delimiter or else how would excel know that 1400 is time and not
One Thousand Four Hundred?

--


Regards,


Peo Sjoblom
 
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)
 
Back
Top