Hi all,



Sorry if the title doesn't make much sense, I'm not sure what I want to do would be called. If a Mod knows of a better title, please feel free to change it

Using Excel 2007, I've downloaded a Baseball schedule in CSV format to import into my Outlook 2007 calendar. However, being in the UK my timezone is GMT and therefore +5 over the ET that is in the schedule.

There are two columns, C is marked START_TIME_ET, B is START_TIME. Column B is designed apparently for your own timezone - and as such I tried to reference cell C2 as below:

In hope that it would change the Time of 1:05 PM in C2 to 6:05 PM in B2 - I would of then imported that column as my start time for my Outlook calendar.

However the formula did nothing. So I checked the cell format and it was:

As such, the data in the cell for to produce 1:05 PM for example is 13:05:00 - would this have any bearing on the reference working or not? Is there a way to achieve what I need?

If anyone could help, I'd appreciate it - I'm not overly clued up on Excel

Many thanks,

Karl