IF you're using the WinXL default 1900 date system, you can't display
negative times, so TEXT() returns the #VALUE! error.

If you use the 1904 date system (Tools/Options/Calculation...) you can
display negative times using TEXT().

NOTE that TEXT() is not necessary, you can use

=H1-I1

by itself, then use

Format/Cell/Number/Custom h:mm

to display the result in the way you want.


In article ,
Jai_Friday wrote:

How can you calculate times??

Initially looking through the help file it shows the following function

=TEXT(H1-I1,"h:mm")

which calculates the diffence in hours and minutes between two times, however

if the values are 00:09:00 and 00:10:00 it won't calculate it give a #VALUE
if the values are 00:10:00 and 00:09:00 it will calculate

What am I doing wrong

Thanks in advance

Jai