What i am trying to do is a hours report to keep track of employees hours. I
will have three sheet..sheet one will be for week 1..sheet 2 will be week 2
and sheet three will be total hours for employees after the two weeks are
done.

example: Oct 1st in time out time total hours
John doe (a1) 5:00(b1) 14:30(c1) 9.5 (d)

i need the formula to get it to avg the hours to get 9.5 i know that it will
be the same for week two.

now on the third page it will be set up like this

week 1 overtime week 2 over time total
hours
john doe 40 3.5 40 0
83.5

thanks for looking