Adding numbers in same cell

[LDMueller]

I have an Excel spreadsheet with names of my staff down
one column and the months across the top. I'm suppose to
enter hours for my staff, but keep a running total for
each user since I'm entering on a daily basis.

The way it's setup, I have one cell for John Doe for the
Month of June. Each day, I enter hours in this cell for
each day of the week. I need to be able to go to a cell,
with the hours in it (for example 1.50) and key 2.00 in
the cell and have it automatically add 1.50+2.00 to give
me 3.50. Each day I want to come and add hours to this
cell and I want a running total.

Is there any better way to handle this than clicking the
formula +1.5+2.0 and adding another +1.75 for example to
keep a running total? I'd like to be able to click on the
cell, key the additional hours and when I leave the cell,
it add the addition to the total that was already there.

Any assistance would be greatly appreciated.

Name June
Amy 15.00
Gina 9.00
Steve 14.00
Barb 11.50
Lisa 15.00
64.50

 

[Paige]

I have 2 suggestions, both involve you using a different
cell for each day.

You can add a column before the June column, use 1 cell
in each row per day, and use the first column as the
summary for June. It would look like this...

Name Autosum Day1 Day2
Amy 3.5 2 1.5

the formula is just =SUM(range of cells to add)

or, you can create another tab in excel as the month
summary and use 1 tab for each of the days, this will
make it neater for viewing the summary. This would use
the same formula as above.

 

[Arvi Laanemets]

Hi

Another suggestion:
Enter 2 (or 2:00, it depends on formats you are using for your data) into
some free cell and copy it.
Select the cell(s), you need to add 2 hours, and right-click on selection
Select PasteSpecial.Add and press OK
Delete the value you copyed

Arvi Laanemets

 

[J.E. McGimpsey]

You're asking how to make an accumulator. While I'd much more
strongly recommend using a range of cells for your entry (to
facilitate error correction), this page may be useful to you:

http://www.mcgimpsey.com/excel/accumulator.html

 

[Myrna Larson]

Believe me, you REALLY don't want to do it this way! What if an employee challenges your total?
How are you going to check your daily entries against his/hers? Use one cell for each day, as
others have suggested. You could put the employee names down column A, the days of the month as
headers across row 1.