calculate working week

[shutzy]

im trying to have a txt box on my for to calculate how many hours are in the staff members working week. my form look like this

sun 09:00 12:00 3
mon 09:00 12:00 3
tues 09:00 12:00 3
wed 09:00 12:00 3
thurs 09:00 12:00 3
fri 09:00 12:00 3
sat 09:00 12:00 3

total hours #ERROR!

for the day by day total i have used =Datediff(h,[Day1StartTime],[Day1FinishTime]

this works but when i try to total them up =Sum([txtDay1Total]+[txtDay2Total])
it comes up with an error.

any help please

 

[Adam Caramon]

Just add the day to day together, i.e. =[Day1Total] + [Day2Total] + [Day3Total], etc.

 

[shutzy]

sometimes its the simple ones that get you