Hi Meg

You could do something similar to the following example.

Requirements:
- I have the hours that I'm working in the B column, starting at B4 and
working down.  
- I want the total days, hours in the C & D columns.  
- I want the days to turn over every 7 hours.

Solution:
- In C4 I put the following formula:   =ROUNDDOWN(SUM($B$4:$B4)/7,0)
**note the lack of "$" before the second B4**
- In D4 I put the following formula: =MOD(SUM($B$4:$B4),7)
- I then copy those formulae down the C & D columns next to the hours in
the B column.
- The numbers there represent the total number of days and hours worked

Would this answer your first question?

Regarding your second question of keeping a running balance over several
pages, perhaps you could specify what you're trying to achieve.  It is
certainly possible to add amounts from several different pages.  E.g.
=SUM(Sheet2:Sheet3!A3:B7) would add up all the values in A3:B7 in all the
sheets from Sheet2 to Sheet3.

Hope this helps