I cant find the question ID but Gustav has a solution that I might be able to use if I can have some pointer how to use it.
Ive inserted the code from this question
Time zones in Access: Specifying/displaying/conv
into my module 1
currently I have a start time which is my local time (spain time so gmt plus whatever) I have a chinese class start time currently this is coded when I start the class it does
TChinese = DateAdd("h", 7, TStartTime)
obviously bad when summertime starts as gmt changes as does spanish time.
for now its manageable but now I will have teachers from other timezones so itll be difficult to hard code and make changes.
so I really need to get the correct time of the teacher timezone and from there it tell me what time the class starts in my time for me and in my bosses time for her (chinese time)
How do I use gustavs solution to achieve this?