E eagleeye Oct 26, 2003 #1 can we have a active clock updating itself automaticaly such as hours and minute and seconds, from any given date and time
can we have a active clock updating itself automaticaly such as hours and minute and seconds, from any given date and time
T Tom Ogilvy Oct 26, 2003 #2 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
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
