Thread: use time functions inside if loop
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default use time functions inside if loop
Try
=IF(A1TIME(1,30,0),"t","f")

If this post helps click Yes
---------------
Jacob Skaria


"saedeepu" wrote:

I have a prob with if loop and time functions.
I want to compare time in one cell with another time.

ex: cell a1- 2:30 , in b2 i want to compare if(a11:30,"t")

it is not coming.
Reply With QuoteReply With Quote