View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CCHILL CCHILL is offline
external usenet poster
 
Posts: 1
Default How do I sum hours from multiple workbooks?

I have created a time tracking sheet that holds the hours for multiple
employees on one sheet. My workbook has sheets for each day of the week with
a summary sheet totaling everyone's hours worked for the week. I have pasted
all the links from the "individual day" worksheets to the Summary worksheet.
I am having problems making the total colum work. It appears that I can not
sum the hours because the cells have links to other pages and the hours add
up to be over 24. What is wrong with my formula?