Date & Time Excel
 

=Now() working Butt Time Is Not Working Like As Clock
Mean As after 60 Second Must Be change the word of min
Like if Now 23:52
after 60 second it will become 23:53
how can i putt that time

Date & Time Excel
 

See Chip Pearson's site for adding OnTime code to run a macro every minute which
would calculate the workbook to change the time.

http://www.cpearson.com/excel/OnTime.aspx


Gord Dibben MS Excel MVP


On Wed, 30 Apr 2008 13:11:00 -0700, Suleman
wrote:

=Now() working Butt Time Is Not Working Like As Clock
Mean As after 60 Second Must Be change the word of min
Like if Now 23:52
after 60 second it will become 23:53
how can i putt that time