So I just got a project from my boss and I basically need to take a year's worth of check-out times for group project rooms (I work in the library at my college) and generate peak times and totals for the check outs. The sheets are organized by time (rows), in half-hour increments, and by room (columns).
So what I'm looking for is a way to basically do tally marks in excel, ideally with just one button press, so I could click the cell, press a key, and it would add a tally to that cell. Currently, when I click a cell and press a key, it overwrites what was in the cell previously.
Is there any way to do this? It doesn't necessarily have to be done in Excel, but I think that would probably be easiest.
Thanks in advance!
edit: OK I found something along the lines of what I want at http://en.allexperts.com/q/Excel-1059/Tally-Counter.htm
It's working pretty well so far.
So what I'm looking for is a way to basically do tally marks in excel, ideally with just one button press, so I could click the cell, press a key, and it would add a tally to that cell. Currently, when I click a cell and press a key, it overwrites what was in the cell previously.
Is there any way to do this? It doesn't necessarily have to be done in Excel, but I think that would probably be easiest.
Thanks in advance!
edit: OK I found something along the lines of what I want at http://en.allexperts.com/q/Excel-1059/Tally-Counter.htm
It's working pretty well so far.
Facebook
Twitter