Help with identifying time and time zones in a formula
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
|