Time Difference

[Rajkumar]

Dear All,

I have some doubt in Date & Time Format.

I have some (time) appearing in a column in this format 7/17/2006
3:20:53 PM..
I need to have a conditional formatting for this in that column.
Ie., if the time in the column is less than 20 minutes to the current
time (ie.,now())
then it should change to some color.

Any help in this regard.

Rajkumar

 

[Bob Phillips]

You could use a conditional format formula of

=AND(A1<=NOW(),A1>=NOW()-TIME(0,20,0))

but it will only update if there is something else that forces a
recalculation

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)