View Single Post
  #8   Report Post  
Newmoon
 
Posts: n/a
Default


Rehi!
something i really did not recognize is that excel changes the datatype
of the cell unasked just when entering something like 7:15.
it is being converted to a number with the category CUSTOM and the
format hh:mm:ss.

however, the SUM-function works correctly on my machine (office2003
installed)
so bobīs assumption that your cells are formatted as text seems to be
the only explainable reason...

...the longer i work with excel the more scatterbrained i become


;) ;) ;)
bye,
newmoon


--
Newmoon
------------------------------------------------------------------------
Newmoon's Profile: http://www.excelforum.com/member.php...o&userid=26172
View this thread: http://www.excelforum.com/showthread...hreadid=394908