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

try this

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

is this what you want.

Steven <[email protected]> wrote in message
news:[email protected]...
> 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

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 <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

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

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

Mangesh



"Steven" <[email protected]> wrote in message
news:[email protected]...
> 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

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

Mangesh



"Steven" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >
> >

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

"Steven" <[email protected]> wrote in message
news:[email protected]...
> 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