I have a problem that I am not sure is suited to Excel.

I want to record the number of hours that each member of a family spend
together for a week. This involves all the combinations of the people.

I have started by creating a worksheet for each person. Listing all the
combinations of people and a column for each day of the week

So for a 4 person family we would have a worksheet tab for the mother
and her relationships.

Mon Tue Wed Thu Fri Sat Sun
Mother
Mother+Father
Mother+Child1
Mother+Child2
Mother+Father+Child1
Mother+Father+Child2
Mother+Father+Child1+Child2

Now if I create a worksheet tab for the father there is some
information that I can use i.e. Mother+Father time should be the same.

I am sure this is not the best way of doing it. I am sure I need to
separate the way the hours are entered from the way they are displayed,
but I'm not sure how.

Can anyone provide a suggestion.