I am trying to create a spreadsheet that will allow me to track my clients' timezones.
I am using the useless
NOW() function to calc current time, and then factor in the time zone value (+/- a #) as so:
But the cells dont update when I refresh. They just stay at whatever time was calculated or recalculated.
How can I get the current time to recalculate when I refresh the page so that all the times will be accurate?
Is there an HTML solution for this that I could use instead?