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!