ExcelBanter - use time functions inside if loop

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - use time functions inside if loop (https://www.excelbanter.com/excel-worksheet-functions/242926-use-time-functions-inside-if-loop.html)

saedeepu

use time functions inside if loop

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.

Jacob Skaria

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.

David Biddulph[_2_]

use time functions inside if loop

=IF(A1TIME(1,30,),"t")
--
David Biddulph

"saedeepu" wrote in message
...
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.

All times are GMT +1. The time now is 04:33 PM.