Thread: question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pierre Pierre is offline
external usenet poster
 
Posts: 149
Default question

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