Scheduling running staff hours

[sse]

Am in the process of creating duty roster spreadsheet for running staffs who travel to different places for days and their duty hours is calculated based on their journey time to and fro.so I need this spreadsheet to calculate hours for a week based on the different places they travelled. OL - Online.Total hours per week should be calculated as H -8 Rest - 0,Place 1 start -2 and so on
My spreadsheet looks like this

Days	Week 1	Week 2	Week 3
Sun	H	Arrival	Rest
Mon	Rest	Rest	H
Tue	H	H	Departure place 2
Wed	H	H	OL
Thu	Departure place 1	E	OL
Fri	OL	E	OL
Sat	OL	E	Arrival
Total Hours per week

 

[awoohaw]

I think it would be helpful if you would provide an example. I really do not follow your statements or the matrix you provide.
Also, the xl2bb add in would provide formulas in addition to the data. Please use that (link below) to share your data, if possible.

Thanks in advance.