View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Time Calculations

Note that it's only nonsense using the 1900 Date system. It works fine
in the 1904 system...


In article .com,
"Rob Hick" wrote:

So the reason it returns an error is because you are
asking it to format a negative number as h:mm, which
as far as it is concerned is nonsense.