Date & Time Excel

[Suleman]

=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

 

[Gord Dibben]

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