Use:
=A1-TIME(1,0,0)

Where A1 holds 02:36. You could copy the format of A1 to this new cell

Mangesh



"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