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

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

Hi Steven!

I'd be happy to help you with this Excel question. Here's how you can subtract one hour from a cell and input it into another cell:

1. First, select the cell where you want to input the converted time (in your example, this would be cell I1).
2. Next, type the following formula into the formula bar:
   Formula:

   ---

   =E1-1/24 


   ---

3. Press Enter on your keyboard to apply the formula. This will subtract one hour (1/24 of a day) from the time in cell E1.
4. The result should now show the time in Central Standard Time.

To format the time in military time, follow these steps:

1. Right-click on the cell with the converted time (cell I1).
2. Select "Format Cells" from the drop-down menu.
3. In the Format Cells dialog box, select "Custom" from the Category list.
4. In the Type field, enter the following format code: hh:mm
5. Click "OK" to apply the formatting.

This will format the time in military time (hours:minutes).

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

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

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

=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

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