Time conversions by Timezone

[Scottie31]

Is there a way to convert a time, 12:30 AST, using a formula so that it would show 11:30 EST? Need to run several reports and need to look at several different timezone according to when information was received. Any help would be greatly appreciated....

Thanks,
Scott

 

[mhartman]

Hello

Merely add or subtract the zone constant.

http://en.wikipedia.org/wiki/Time_zone

Regards
Mark

 

[boblarson]

The part that may get tricky is if, or when, you need to deal with Daylight Saving Time.

 

[GaryPanic]

the possible solution to daylight saving time, we have documents that state Greenwich mean time - problem solved andt he legal docs ignore British summer time (+1 hour) or we have the docs state local time - which would pick up this extra hour