On Jan 21, 1:14*pm, Ed wrote:
How do I get the NOW() function to continuously update in the hours, minutes,
second format, like a digital clock.

Any help would be appreciated.
--
Ed

You might want to check this site out. It also has a downloadable
spreadsheet with the sample
http://www.dailydoseofexcel.com/arch...digital-clock/