google apps script - Need to implement a function providing US (Canada also if possible) states Local time based on the state

Question

I need to implement a function providing US (Canada also if possible) states Local time based on the state. - https://docs.google.com/spreadsheets/d/1JS6YhSpslJMVAATz5SMc_UXQ3SIjGaVLUZCWvIJ0V2o/edit#gid=0 Can we get real time updates for this? I'd be okay with a script or a google sheet formula. Also can we have a chart with time zone by state? It would great if we can get real time updates for this too.

Answer 1

等待大神答复