View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mr BT[_2_] Mr BT[_2_] is offline
external usenet poster
 
Posts: 20
Default Help with identifying time and time zones in a formula

=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