total of hours worked

I need some help! I need to make a spreadsheet to calculate our weekly time. I have all the data entered and everything is going great until I get to the total hours worked.

How can I get a calculation of the total hours worked during the week? I also need another column showing +/- hours for the week. (I calculate time daily so if you work 8hr, 10min you have +10mins...we have comp time for anything worked over an 8hr day.)

Did my request make sense?? Can you give me some guidence??

Hello carolynkeene, If you can post your spreadhseet by zipping it up and uploading it I am sure we can assist you with what you need to accomplish.
Also there are many spreadsheets here that are calculating timesheets

Let me try uploading it...

Hope it worked!

Hello,
I was able to tally your totals but the formulas I use seem to have a minor rounding issue as you can see.

but you can see that by formatting the different cells with time formats that I was able to tally
hope this helps you


Maybe someone else here can be of better assistance

You may also wish to take a look at the following
http://j-walk.com/ss/excel/files/timesht.htm