Time Difference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rajkumar - 17 Jul 2006 13:06 GMT

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

Signature

Rajkumar

Eager to learn more about Excel

Reply to this Message

Bob Phillips - 17 Jul 2006 14:00 GMT

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

Signature

HTH

Bob Phillips

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

> Dear All,
>
[quoted text clipped - 10 lines]
>
> Rajkumar

Reply to this Message

Rate this thread: