Time format of hours/minutes from date stamp (GMT time)

[zagzebski]

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,

Steve

[maxgro]

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