daily total hours

I'm new to the forum!! I am working on a spreadsheet for our timekeeper. I have the daily time functions done and everything seems to be working fine except for...I have to calculate the weekly time. I need to know the amount of time a person worked over or short for the week. Here is an example of my spreadsheet:

Thursday Friday Weekly Total
Time In 6:59 AM 7:11 AM
Time Out 5:39 PM 5:29 PM
Luch 0:30 0:30

Daily Total 10:10 9:48 #VALUE!
+\- Time 0:10 -0:12 #VAULE!


How to I get the weekly totals???

Thanks in advance!!

Carolyn

What formulas are you using to get the daily totals and under/over amount?
If you use the correct formulas for these you can probably get the total just by summing them.

If in time is in A2, out time in A3 and lunch in A4 try

=A3-A2-A4

for daily total hours

can your shifts finish the next day or will work always end the same day as it starts?