question

[pierre]

hi
i have 2 questions:

first:
i inserted the following formula :
=TIME(HOUR(NOW());MINUTE(NOW());SECOND(NOW()))
and that in order to have a CLOCK to be exactly like the system
timer....but my problem is that i need this clock inside my formula to be
compatible with my system timer...
in example....:
suppose that my formula indicates now 04:12 pm ...
when i leave and come back a few minutes later i notice that the clock in my
computer indicates for example 04:14 pm BUT THE CLOCK IN MY FORMULA REMAIN
THE SAME....04:12 pm
HOW TO MAKE THEM WORK AND CHANGE TOGETHER ?????

second question :
i went to : format cell----> custom ----->i entered : -0.00
HOW TO MAKE IN RED COLOR ???
AND HOW TO MAKE IN RED COLOR + ( )

THANK YOU

 

[Bob Phillips]

1 - run this macro



Sub UpdateTime()
Worksheets("Sheet2").Range("A1").Value = Time '<== change to suit
Application.OnTime Now + TimeSerial(0, 0, 1), "UpdateTime"
End Su

2 create a custom format of 0.00;[Red]-0.00

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)