Timestamp Issue

[marlku1234]

HI I have a timestamp field where the data is coming as GMT-5   which is est time zone and the format is 05:22:09.000000.

now i want to change this to Est time zone and use bellow expression 

=Time(ConvertToLocalTime(ResTime,'UTC+01:00'),'HH:MM:SS TT')     /// This is giving me est time but the minute is not matching / its coming as 06:12:09 AM,   

[Vegar · Accepted solution]

There is a difference between 'MM' and 'mm'. 

• 'MM' is Month in two digits 
• 'mm' is minutes in two digits.

Try using 'hh:mm:ss TT' as your format string.