Adding 3 hours to a time

[djbrandok]

Hello all!
I have a column in my excel worksheet with the date and time. Here is what the data looks like: 1/3/16 1:08 PM

This is West coast time and I need to convert it to East coast time by adding 3 hours. Is there a function/formula for that?

Thanks in advance!

[Jonmo1]

You can do

=A1+TIME(3,0,0)
or
=A1+"3:00:00"

[Ron Coderre]

With
A1: a date/time value: 1/3/2016 1:08:00 PM

Either of these formulas add 3 hours to that time

Please Login or Register  to view this content.

or...you could change the actual values

Please Login or Register  to view this content.

Does that help?

[djbrandok]

Fantastic! I tried out the multiple solutions and they all worked, thank you both very much!

[Jonmo1]

You're welcome.

[djbrandok]

Sorry to ask for something else, but I want to create a new column with additional functions.

With that newly created column (the +3 hour one), I want to create two more columns. One has the day of the week (i.e. Sunday), the next one has the hour of the day (i.e. 4: 08 PM).

When I try to create the next column, I input =TEXT(H2,”dddd”) and I get #NAME? as the result. H2 column is the column that I created using your formulas to add 3 hours.

So long story short:

I have column G with the date and time 1/3/16 4:08 PM.
I want to create column H that has 1/3/16 7:08 PM.
I want to create a column I with the Sunday (the day of 1/3/16)
I want to create a column J that has the hour of the day 4:08 PM

[Jonmo1]

I don't know how they got there, but those quote marks look weird, and I get the same result when copy pasting your formula to my sheet.
=TEXT(H2,”dddd”)

Try
=TEXT(H2,"dddd")

[djbrandok]

Bingo! Thanks again Jonmo1!

[Jonmo1]

You're welcome, I think that happens if you type the formula in another application (like word) and then copy it from that application into Excel.