Question about writing as formula in excel

Need to total Actual hours worked column for 26 weeks  for year to date purposes
Spreadsheet is on 2 separate worksheets within workbook.
This formula will be located within a different, separate workbook
Example of sheet and column names :  - see attachment
 '2008 TIMECARD' !d4,s4,ah4,aw4,bl4,ca4,cp4,de4,dt4,ei4,ex4,fm4,gb4  1st timesheet
 '2008 TIMECARD 2' !d4,s4,ah4,aw4,bl4,ca4,cp4,de4,dt4,ei4,ex4,fm4,gb4  2nd timesheet

A      B      C      D      E      F      G      H      I      J      K
Employee Name:      empname      07/06/08      -      07/19/08                                    
Employee ID:      86738      Due Date      Wed      07/16/08                                    
              Hours Budgeted      Actual Hours Worked      Total Paid Hours      Paid Vac. Leave      Paid Holiday Leave      Paid Personal Leave      Paid Sick Leave      Paid JD Leave      Paid Bev Leave
03.80400      Core      4.00      4.0      4.44      0.44      -      -      -      -      -
03.80463      Chang PAM      8.00      12.0      13.33      1.33      -      -      -      -      -

Thanks.

Start Free Trial