How do I sum hours from multiple workbooks?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
select the cell with the formula

do format=>Cell=>Number Tab, go to time and select 37:30:55. alternately
you can go to custom rather than time and type in [hh]:mm:ss or [hh]:mm

That should give you the right answer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vlookup and sumif function maybe a macro issue? 0
Error Message - Macro to Unlink MS Queries from Workbook 0
Sum work hours to hours & nearest 10th of an hour 14
Copying same data range to a summary sheet 8
autofilter master copy data to worksheet 1
Add Hours by Looping through Data Q 27
Search , then copy and paste from multiple worksheets. VBA help 1
Reduce duplicates to 1 with a count of how many before 42

Back
Top