=A1-TIME(1,0,0)
A1 has 02:36

Mangesh



"Steven" wrote in message
...
Well that was too easy. Thank you very much !!!

"R.VENKATARAMAN" wrote:

try this

A1 B1 C1=A1-B1
2:36 1:00 1:36

is this what you want.

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