=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

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
---------------
Jacob Skaria


"Mr BT" wrote:

=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