Thread: use the current time to return a value
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
tony h[_5_] tony h[_5_] is offline
external usenet poster
  
Posts: 1
Default use the current time to return a value

The other thing that can confuse is that if the cell A1 is formatted a
TIME it will display a time even though it has a date. Therefore yo
may need to take the fractional part of cell A1 which can be done b
substituting TIMEVALUE(A1) for the A! in the previous answer.

you can see this in :
timevalue(time)=time which is true and
timevalue(now)=now which is false

hope this help

--
tony
-----------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=48874

Reply With QuoteReply With Quote