Automatically show the current time with hours, minutes and seconds with a formule

Hello,
I wanted to use this subroutine as a formula =TimeStamp()
The script will show the current time in hours, minutes and seconds.

Please Login or Register  to view this content.

Could someone give me some help?

Thanks in advance,
grid

Try this

Please Login or Register  to view this content.

Note that grid is asking for a Function. However, a function won't give you a timestamp because it will be reevaluated on recalculate. So you need a Sub.

Maybe a little more explanation of the context of how you will use this will help us get you a better answer.

And:

Originally Posted by alansidman

Try this

Please Login or Register  to view this content.

The result from this code is the same the result from Sub TimeStamp in the OP, but takes more steps to get there.

Aha. You want...a "clock". Yes, this code is one way of getting that, it will update the time once per second.

Here is the code enhanced to include the ability to cancel the timer, if you need to.

Please Login or Register  to view this content.