Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set the time counter?
Does anyone know how to set the time counter in excel?
such as if( current time is between 10 am and 11 am, if(current second is between 01 and 30, "A", "B") ,false), which show "A" whenever the current second is between 01 and 30 during the periods 10 am and 11 am, and show "B" whenever the current second is between 31 - 00 during the periods 10 am and 11 am. Does anyone have any suggestion? Thank you for any suggestion Eric Choi |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set the time counter?
=IF(AND(HOUR(NOW())=10,MINUTE(NOW())<60),IF(SECOND (NOW())<=30,"A","B"))
But watch out! The formula refreshes its value only after a Calculation is done! Regards, Stefi €žEric€ť ezt Ă*rta: Does anyone know how to set the time counter in excel? such as if( current time is between 10 am and 11 am, if(current second is between 01 and 30, "A", "B") ,false), which show "A" whenever the current second is between 01 and 30 during the periods 10 am and 11 am, and show "B" whenever the current second is between 31 - 00 during the periods 10 am and 11 am. Does anyone have any suggestion? Thank you for any suggestion Eric Choi |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set the time counter?
Do you know any feature to refresh spreadsheet automatically? so I don't need
to push F9 button for refreshing all calculation? Thank you very much Eric "Stefi" wrote: =IF(AND(HOUR(NOW())=10,MINUTE(NOW())<60),IF(SECOND (NOW())<=30,"A","B")) But watch out! The formula refreshes its value only after a Calculation is done! Regards, Stefi €žEric€ť ezt Ă*rta: Does anyone know how to set the time counter in excel? such as if( current time is between 10 am and 11 am, if(current second is between 01 and 30, "A", "B") ,false), which show "A" whenever the current second is between 01 and 30 during the periods 10 am and 11 am, and show "B" whenever the current second is between 31 - 00 during the periods 10 am and 11 am. Does anyone have any suggestion? Thank you for any suggestion Eric Choi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
Can this be done?? | Excel Discussion (Misc queries) | |||
formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
Hot key for time? | Excel Worksheet Functions | |||
time sheet drop down lists | Excel Discussion (Misc queries) |