I have a field TIMESTAMP that is in the in the following format as an example : 11/15/2005 4:30:00 PM
I need to convert this time which is in GMT to Central Standard Time in just hours minutes ( 16:30 as an example)
Thanks in advance,
I think with ConvertTo...., see online help
=time(frac(ConvertToLocalTime(date#('11/15/2005 4:30:00 PM', 'MM/DD/YYYY hh:mm:ss tt'), 'Fuso centrale (USA e Canada)') ),'hh:mm')
adapt bold to your pc
Retrieving data ...