Help with identifying time and time zones in a formula

[Mr BT]

=Q278&" "&TEXT(J278,"hh:mm")&" CST "&N278&", "&P278&" SAB"
I have the above formula in column M where column J will be entered the
current time.
I need the time to be equivalent to Eastern Standard Time rather than
Central as it displays when I use Ctrl+SHIFT+;
Can anyone suggest how I would add an hour to the display of the time I
enter with the above shortcuts?
Thanks

 

[Jacob Skaria]

To add one hour more use the TIME() function and + operator

=Q278&" "&TEXT(J278+TIME(1,0,0),"hh:mm")&" CST "&N278&", "&P278&" SAB"

If this post helps click Yes