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 |
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 |
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 |
All times are GMT +1. The time now is 12:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com