Hi!

Here's an alternative that doesn't require the need for a helper column and
can be done en mass.

In an empty cell enter: =1/24

Select that cell and copy it. Then goto EditPaste SpecialValues

Copy that cell again

Now select the range of cells that hold the times

Then goto EditPaste SpecialSubtract

Format as TIME

Biff

"Steven" wrote in message
...
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