How do I sum hours from multiple workbooks?

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?
 
T

Tom Ogilvy

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

Copying same data range to a summary sheet 8
Sum Hours over 24 hours in Access Report 0
Add Hours by Looping through Data Q 27
Search , then copy and paste from multiple worksheets. VBA help 1
sum of hours 4
Sum data from multiple Workbooks. 1
Adding Hours Worked Correctly 3
Copying specific cell ranges from a worksheet multiple times to a newsheet 3

Top