Hello,

Can you please help me write a formula to convert US Eastern time (ET) to India time zone (IST) in crystal report and display IST instead of ET in the report.

I have the following filed which i use for date and time which display US time zone.


{probsummarym1.open.time}


Sample Data

10/30/08 09:32:00 AM ET

10/30/08 10:35:00 PM ET

10/30/08 11:50:00 AM ET

10/30/08 08:53:00 PM ET

10/30/08 07:54:00 AM ET

10/30/08 06:59:00 PM ET

10/30/08 05:03:00 PM ET