View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default single cell time entry as time - time; Ever seen this?

Hi Joe,

Am Wed, 29 Jan 2014 01:46:34 -0800 schrieb joeu2004:

Because in that context, you are comparing the string "7:00" with the number
TIME(7,0,0). Try:


I don't know why I have done this :-(
Sorry, my bad


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2