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

Hello

Merely add or subtract the zone constant.

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

Regards
Mark

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

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