Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
question
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) "pierre" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |