Hi all.

I am using the following formula

=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))

to return the local time.

However, the time does not update unless I either update the formula or plug another formula somwhere else.

I am preparing this as part of a tool for my team and it would be helpful if I could get the time to update on its own without user input. Is this possible?

Thank you in advance.