I have made a rota for several staff
I can auto add the days hours but am unable to add the wekks hours

Date Day Neil
On Off Tot
29-Jul-05 Fri 9:30 22:00 12:30
30-Jul-05 Sat 9:30 22:00 12:30
31-Jul-05 Sun 9:30 22:00 12:30
01-Aug-05 Mon 9:30 22:00 12:30
02-Aug-05 Tues 9:30 22:00 12:30
03-Aug-05 Wed 9:30 22:00 12:30
04-Aug-05 Thur 9:30 22:00 12:30
Total Hours 15:30


This is a sample
Any help please