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

=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

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