how do i modify the time given?

[bigdan]

I have a number of events in which the time and date is given. For example "[UTCTime "22:04:02"]". I'm in a different timezone so I'm going to make a new column saying "Canada Time" and I'd like to add 4 hours to that. In that column I wrote =A1+4 but that didn't work. Then I tried changing the above to "22:04:02" (ie took out the text) and then in a diff cell tried adding 4 to that, which also didn't work. Please help!

 

[AhoyNC]

Maybe something like this:
Note: In Excel 1 hour is equal to 1/24 of a day. So 4 hours = 4/24 or 0.166667.

Book1
	A	B
1	[UTCTime "22:04:02"]	2:04:02
Sheet1

Cell Formulas
Range	Formula
B1	B1	=MID(A1,11,8)+(4/24)

 

[bigdan]

Thanks! I'm afraid that didn't work, or at least isn't the final result I'm looking for. In the example I tested [UTCTime "22:04:02"] ended up as 1.086134259

 

[Fluff]

You need to format the cell as time.