Creating a population of total hours worked for that week ?

**calamityjane** · 09-13-2012, 04:12 PM

Here I have a spread sheet on a timesheet.

I would like to put in formula that would automatically populate the total hours that week, per employee. I have 5 employees
and the week runs from Monday - Sunday. Their jobs vary through out the day and are also timed in sections of duties per those hours. example : 3 hours of x , 4 hours of x . I can add those easily , but as long as I can get the ending total hours per week per line.

Any help will be very much appreciated

Thank you

**calamityjane** · 09-13-2012, 04:16 PM

Also I'm a very new beginner. I would like to learn more as I go.

**Oredigger90** · 09-13-2012, 04:18 PM

This sounds like a pretty easy to make macro, do you have any experience with macros? If not that's no big deal, I'd be happy to write one. If you could post an example starting file, just about 50x50 data cells or a little more; and also your expected result file after the program is run; that would be the easiest method for sure. You can just make up names or dummy names but it's about impossible to write code without the files. Thanks!

**FDibbins** · 09-13-2012, 04:30 PM

this can probably be done thru a fformula too, but as suggested, a small sample file will enable us to help you better

**calamityjane** · 09-13-2012, 04:48 PM

time sheet
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
days 9/3/2012 9/4/2012 9/5/2012 9/6/2012 9/7/2012 9/8/2012 9/9/2012
Albrecht, John 10.5 10
Brown, Kent 11 11 11
Tracy, Charles 10 12 12 12 12
Wayne Parry 3 11.5 10.5
Allen Pehringer

Here is an example ? The total will be on the end right column, I hope

**calamityjane** · 09-13-2012, 04:49 PM

the # hours goes to the date column

**calamityjane** · 09-13-2012, 04:49 PM

I'm wondering if this somehow can't be exported or auto done in Oracle ?

**calamityjane** · 09-13-2012, 04:59 PM

Originally Posted by Oredigger90

This sounds like a pretty easy to make macro, do you have any experience with macros? If not that's no big deal, I'd be happy to write one. If you could post an example starting file, just about 50x50 data cells or a little more; and also your expected result file after the program is run; that would be the easiest method for sure. You can just make up names or dummy names but it's about impossible to write code without the files. Thanks!

I am not familiar with Macro either. Do they offer classes for Excel ?

**calamityjane** · 09-13-2012, 06:00 PM

SOLVED ! Had some help at work .

The formula was alot simpler than I thought.

Just highlight the lines you're totaling, tab over to next column, press <ALT => and it populates. You can also add vertically. Duh ! I need to learn some basics. Thanks for all your help.

**Cutter** · 09-15-2012, 08:43 PM

@ calamityjane

Welcome to the forum.

Based on your last post it seems that you found a solution to your problem but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.