View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Duncan[_5_] Duncan[_5_] is offline
external usenet poster
 
Posts: 290
Default #N/A error matching time values

Yep,

used the fill/copy handle and have tried various ways of formatting to
replicate your error to no avail....

confusing....!

Try using the format I suggested above (bracketed single H) and let me
know if you still get this problem

Duncan


excelent wrote:

when i start all cells is formatted as standard
then i put directly 00:02 ENTER
and Excell format this as hh:mm

did u try put in manualy all times in 1 column and
in the other column use fill/copy handle ?