L
ladyinblack1964
Hi, Folks, I wouldn't exactly say I'm NEW to Excel, as I used it in
past job, but I never quite got the hang of it. And with the changes t
Office 2010, eeek!
I could use some help. I think the spreadsheet I need to create i
pretty easy--I just can't quite picture it in my mind.
First, I am using 2010 at home but I see you can backsave to 2003 whic
is what I am using at my very new job. I want to make my (and everyone'
life easier).
Here is the story: It's a library. We let patrons use six computers
They come in, and we hand them a physical number (like for a dressin
room in a store) and on a chart, we sign them in, such as: "John: in a
10:30 a.m." Then when they depart, we take back their number and ente
"out at 1:30 p.m." next to John's name.
Part of my new job is to do a statistical spreadsheet. This is alread
set up. There are two of them in the workbook: One is the number o
patrons who use the computers per day; the other is how many hours pe
day they were used.
The previous employee was calculating the difference in time between
say, 10:30 and 1:30 and putting down "180 mins." then dividing by 60 an
coming up with the average amount of hours on the computers in that way
I also must count the number of patrons who used the computers. Which i
easy to do by hand.
BUT...
I know Excel can calculate hours in this fashion. And I know that it ca
do averages. I just don't know how it might be best to set up thi
spreadsheet. I know I need subtotals (for each day) and I know I need t
calculate the hours and do an average of hours for each day.
Can anyone help? Please! This will save me a ton of work.
Even if you just direct me to a couple of good tutorials, that's bette
than my Googling all over the place.
Thank you
past job, but I never quite got the hang of it. And with the changes t
Office 2010, eeek!
I could use some help. I think the spreadsheet I need to create i
pretty easy--I just can't quite picture it in my mind.
First, I am using 2010 at home but I see you can backsave to 2003 whic
is what I am using at my very new job. I want to make my (and everyone'
life easier).
Here is the story: It's a library. We let patrons use six computers
They come in, and we hand them a physical number (like for a dressin
room in a store) and on a chart, we sign them in, such as: "John: in a
10:30 a.m." Then when they depart, we take back their number and ente
"out at 1:30 p.m." next to John's name.
Part of my new job is to do a statistical spreadsheet. This is alread
set up. There are two of them in the workbook: One is the number o
patrons who use the computers per day; the other is how many hours pe
day they were used.
The previous employee was calculating the difference in time between
say, 10:30 and 1:30 and putting down "180 mins." then dividing by 60 an
coming up with the average amount of hours on the computers in that way
I also must count the number of patrons who used the computers. Which i
easy to do by hand.
BUT...
I know Excel can calculate hours in this fashion. And I know that it ca
do averages. I just don't know how it might be best to set up thi
spreadsheet. I know I need subtotals (for each day) and I know I need t
calculate the hours and do an average of hours for each day.
Can anyone help? Please! This will save me a ton of work.
Even if you just direct me to a couple of good tutorials, that's bette
than my Googling all over the place.
Thank you