time

[eagleeye]

can we have a active clock updating itself automaticaly such as hours
and minute and seconds, from any given date and time

 

[Tom Ogilvy]

You can put Now() in a cell and subtract your start date and time from it.
Then force a recalc every second using a macro. Then forget about using
Excel for anything else.

See Chip Pearson's site for

Application.OnTime

http://www.cpearson.com/ss/excel/ontime.htm