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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtract one hour from time 6
Subtract one hour. 2
Subtract 1 random no. in col from another without naming cells? 3
How do I round time down to the nearest half hour? 3
How do I multiply an hourly cost by hours expressed in minutes? 3
How can I subtract one date and time from another in Excell? 8
subtract the time difference from another time difference 3
How do I subtract 8 business hours from a date/time value? 5

Back
Top