Adding or subtracting time to a field value

J

Johan

I have a form which contains a date and time field set to display the current
date and time when the form is completed. there is a second field (drop down
list ) where the user selects one of 3 different time zones.

I need to have a third field which will contain the time in a fourth time
zone calculated based on the first 2 fields.

Example,
Field 2 shows time zone Aust EST (GMT+10). the thirdt field needs to take
the first field and subtract 10 hours to give equivilant GMT time.
OR
Field 2 shows PDT (GMT-8). the third field has to add 8 hours to give GMT.

Hope this makes sense
Johan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Zone Conversion Table 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
2016 Project, adding a workday to custom field 0
Changing time zones 2
Convert to PST from GMT time 2
Time Calculations..subtracting Minutes 3
Default time zones for imported events 3

Top