Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
IF question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
question | Excel Worksheet Functions |