How do I subtract 1 hour from one cell and input it another?

S

Steven

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
 
M

Mangesh Yadav

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

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

Mangesh
 
B

Biff

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 Edit>Paste Special>Values

Copy that cell again

Now select the range of cells that hold the times

Then goto Edit>Paste Special>Subtract

Format as TIME

Biff
 
Top