Try:

=HYPERLINK("[G:\2010-2011\Time Table 2010 - 2011.xlsx]'Lecture Hours'!B"&COLUMNS($A$1:G$1), COLUMNS($A$1:F$1))