Time formula

Hi Paul, Thank you for the post, welcome to the forum, good question, in answer; =now() like =today() is an active formula which updates each time you open Excel, in the case of the =now() formula you can update this by pressing the F9 (Function 9) key at any time anywhere in the worksheet. If you have HH:MM:SS as your format you will see the seconds increase. Sadly there is not a formula to insert a ticking clock. Hope that has helped a bit, if so please click the Resolved link. Best regards Pete