View Single Post
  #1   Report Post  
Steven
 
Posts: n/a
Default How do I subtract 1 hour from one cell and input it another?

Hello.
I download a spreadsheet every week and the times show up in Easter Standard
Time. I need to convert this to Central Standard Time by subtracting one
hour. Additionally these times will be military time.

i.e. E1 (EST) I want: (CST)
02:36 1:36 A.M.

Thank you,
Steven