how to

M

Meg

Here's the scenario, I have to accumulate hours and days that I work. I am
only paid a day rate. yet sometimes I work an hour here and an hour there.
When I reach a certain number of hours, I have to bill for a full day rate.

Is there a way to keep a running total and when it hits that magic number,
it will create an entry the day billing column and reset the hour tracking
column to zero????

Also,

how to keep a running balance from one sheet to another

Thanks

Excel 2002
windows Xp
 
G

glenton

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
 
Top