ExcelBanter - adding time zones to formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - adding time zones to formatting (https://www.excelbanter.com/excel-worksheet-functions/13698-adding-time-zones-formatting.html)

tjb

adding time zones to formatting

Is there a way to add a time zone to an auto-format? For instance, I have a
sheet that enters the current time into a particular cell when a command
button is activated but my users are in different time zones across the U.S.,
any suggestions?

All times are GMT +1. The time now is 10:05 PM.