Simple time calc

[hsandeep]

Sheet1

	A	B	C

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 115px"><col style="WIDTH: 115px"><col style="WIDTH: 64px"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="align: center"]Result[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="bgcolor: #ffcc99, align: right"]9/23/14 10:00 AM[/TD]
[TD="bgcolor: #ffcc99, align: right"]9/23/14 10:30 AM[/TD]
[TD="bgcolor: #ffff00"] [/TD]

</tbody>

C=1, If 'system's time>=A2 & <B2 else 0.
Formula needed for C2?
Thanks.

Excel tables to the web >> Excel Jeanie HTML 4

 

[pbornemeier]

A2 Your input as a date/time value
B2 =Now()
C2 =IF(B2>=A2,1,"")

B2 is system time
C2 will contain nothing if system time is less than system time

 

[hsandeep]

A2 & B2 BOTH are INPUT as date/time value.
Output in C2 & to be copied down.

 

[NeonRedSharpie]

A2 & B2 BOTH are INPUT as date/time value.
Output in C2 & to be copied down.

So...what's your concern with the response posted above?

 

[hsandeep]

<b2 else="" 0.
Formula needed for C2?

C2=1, If 'system's time>=A2 & less than B2 else 0<b2< b2=""></b2<></b2>

 

[NeonRedSharpie]

<b2 else="" 0.
Formula needed for c2?

C2=1, if 'system's time>=a2 & less than b2 else 0<b2< b2=""></b2<></b2>

=if(and(now()>=a2, now()<=b2), 1, 0)

 

[hsandeep]

Thanks. It works.