View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
 
Posts: 695
Default #N/A error matching time values

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 ?