Originally Posted by
prefnet
. . . Now that you've entices me with a function, . . .
Very bare bones, only for Eastern Time.
Then formulas like
=A3-((5-EDST(A3))&":00")
Slightly more general,
=A2-((5-DST(A2,-5))&":00")
Both functions return TRUE/FALSE whether their 1st, UTC, argument is during daylight savings time. The 1st assumes Eastern time zone. The 2nd takes the standard time adjustment from UTC as 2nd argument.
The real trick would be taking UTC and a POSIX time zone spec like EST+5EDT,M3.2.0/2,M11.1.0/2 and returning corresponding local time, but I don't want to reinvent that wheel.
Bookmarks