This is because, when you enter fixed time like '09:15:30' in a cell, it translates to 00-Jan-1990 09:15:30 and the system time translates to 13-Oct-2018 08:15:00.
You can clearly see, D1 is greater than E1 i.e. D1 is earlier date. So we need to match dates in both. To do that; simple put this in D1 (Current time) =TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))
Now D1 will translate to 00-Jan-1990 08:15:00 Both D1 & E1 dates are same, your formula =IF(D1 will work now.
@HowUTrade Can you please let me know about where can I find documentation about KiteXL (regarding it's capabilities and how to use it)? The link to your website on kite forums is not working.
This is because, when you enter fixed time like '09:15:30' in a cell, it translates to 00-Jan-1990 09:15:30 and the system time translates to 13-Oct-2018 08:15:00.
You can clearly see, D1 is greater than E1 i.e. D1 is earlier date.
So we need to match dates in both.
To do that;
simple put this in D1 (Current time)
=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))
Now D1 will translate to 00-Jan-1990 08:15:00
Both D1 & E1 dates are same, your formula =IF(D1 will work now.
Get start from here
https://howutrade.in/docs/kitenet/html/Introduction.htm