Job Hour tracking with pivot tables

**charlie13** · 05-19-2009, 04:49 PM

I have an Excel timesheet that the supervisor loads the time (in and out) for all the shop employees. These employees may work up to six different jobs in one day at various points throughout the day. I have no problem with calcs and formats on the daily time entry tab (sheet1). What I need is a way to track each job using a running total so that as the job is in progress we can see how we are doing against estimated hours. I thought perhaps I should at least make a weekly time summary pivot table thinking that it would make it easier to calculate, but it didn't help with running totals. The summary included (5) copies of the same daily entry tab (sheet1) just given a different name, in this case ..a simple date change and save the sheet with the date used. OK, here's the problem. How do I create a running total that would track each job? I forgot to mention earlier that each daily time entry sheet is saved and named by the date for which it represents. The weekly time summary pivot table works fine....but it only gives me the grand total of hours worked for each day...not a running total summary. I can view the pivot tables and go to the calcualtor and add the hours up per job, but that's defeating the purpose. Anyway, I hope this is clear enough to at least get some responses. Then, maybe by then I'll have a better understanding how to ask the right questions.

Check out the weekly time summary pivot table...hope I can upload.

Newbie to Forum

Thanks everybody!

Charlie

**shg** · 05-19-2009, 04:56 PM

Welcome to the forum, Charlie.

Please take a few minutes to read the forum rules (link in menu bar), and then amend your thread title accordingly.

**charlie13** · 05-27-2009, 08:20 AM

Well, I read the rules...changed the title...have I missed something? I hope that my thread is clear enough to understand. Any help would be greatly appreciated.

**Vinodsralian** · 05-30-2009, 03:33 AM

Try using the format I have shown while saving the data. This could be easy for you to calculate the way you desire the Pivot to look.
Hope it helps!!

**charlie13** · 06-01-2009, 01:03 PM

Hey Vino,

Thanks so much for all the help. I tried to get my pivot to look the way you have it, and was unsuccessful. At least now, I have something I can work with. Again, thank you...thank you!

Charlie

**charlie13** · 06-02-2009, 09:28 AM

Hello Vino,

I did have a couple of questions after viewing your revision of the pivot table. First, how do I edit the table to include the two remaining days of the week which do not appear in your revised pivot? Secondly, I noticed that you did not respond to the "running totals" question I had also asked in the original thread. How do I create a running totals column that tracks hours for each job? I certainly want to thank you again for what you have already provided. If I could have your assistance on these two questions, I believe I could take it from there and really start to make some headway. Thank you in advance for any help you may provide.

Charlie

**Vinodsralian** · 06-04-2009, 06:33 AM

Please view attached doc..

**charlie13** · 06-10-2009, 04:25 PM

Hey Vino,

Thank you for all the help you have given me thus far. I just need to ask one more thing if I could. As you showed me, I added the 15th & 16th to the calcs and then edited the pivot and it all looks great. My problem is that I need to roll these total job hours over to Monday of the next week so that I can have a running total. Can you show me how to do that?

Thanks!

Charlie

**Daniel Black** · 07-08-2009, 06:25 AM

Help Im trying to calculate the number of hours worked on different projects but im having real trouble,
I have calculated manually that a caseworker has completed one piece of work for 95 minutes and should appear as 1.35 but currently appears as 192.00 even with the cell formatted with [H]:mm

can someone please help me??????????

**DonkeyOte** · 07-08-2009, 06:30 AM

Per your other post

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.