Timesheet

[Raphiuz]

Good evenning!

I have a sheet for diary filling and another one, in the same workbook, that resume the day by acummulating the hours spend in each project and calculating the cost for each projects.
What i need to find, is a way to export daily data to another sheet that acumulates the daily data (by day), in form to make a weekly an monthly reports of what project spend more time and money.

Can you please at least tell me if this is possible?

I'm using version 2003.

Sorry for my written errors. I'm portuguese

 

[cyrilbrd]

Hi,
Have you tried Pivot Table?

 

[Raphiuz]

I don't know what is that!! I will search at the web to see if i get it! I can uplod the worksheet i got but i don't know how to post!! Do you see what i want? Is it very hard to do?

Thank you for your reponse.

 

[Raphiuz]

Hi,
Have you tried Pivot Table?

Ok, now i see what is a pivot table. Unfortunely from me, that's not what i want!

I think that it is possible by VBA solutions, but i only know working in excel with functions.

i think that if you see my work sheet you'll get it!

 

[cyrilbrd]

ok when you type the reply, look at the icons above... one of them is <>
it is an HTML wrap, use it to send your data.
open excel, highlight your data, copy then go to the forum, click on <>
then
"

[ /HTML]" will appear, insert the cursor in the middle of the ][ and paste...

 

[Raphiuz]

           Diary   timesheet       
   
                                       
   
           Name of   Employee:   Raphael       
   
           Date:   quarta-feira,   22 de Fevereiro de 2012       
   
                                           
   
               Project code   Start   End   Total time (by project)       
   
           Brief description of the task   Hora   Min.   Hora   Min.       
   
               (1-23)   (1-59)   (1-23)   (1-59)       
   
           Orçamentos   D03   08   00   09   15   1:15       
   
           Reunião Administrador   D05   09   15   12   00   2:45       
   
           Encomendas   D03   12   00   12   30   0:30       
   
           Tradução documento   D07   13   30   14   00   0:30       
   
           Reunião Administrador   D04   14   00   15   30   1:30       
   
           Elaboração folha de tempos   D05   15   30   18   00   2:30

This is the data filling by the Employees. This data filling should be like a template, see? And the sheet i post below will be the data base of the day.

           TOTAL   TIME/COST BY DEPARTMENT       
   
                                   
   
           Name of   Employee:   Raphael       
   
                                   
   
           Date:   quarta-feira,   22 de Fevereiro de 2012       
   
           
   
   
   
           
   
           Hour Cost:   20,00 €               
   
                                   
   
           Project code   Project denomination   Worked   Hour   Amount       
   
           Time   Cost   to be paid       
   
           D01   a                   
   
           D02   b                   
   
           D03   c   1:45   20,00 €   35,00 €       
   
           D04   d   1:30   20,00 €   30,00 €       
   
           D05   e   5:15   20,00 €   105,00 €       
   
           D06   f                   
   
           D07   g   0:30   20,00 €   10,00 €       
   
               
                   
   
               Total earnings (hours / Value):   9:00   
   180,00 €

What i need is other sheet that mekes me the resume of weeks, months...

This will happen if when you fill a new day data, it would create a new resume of the day data, and the resume of the days data, will fill automatically!

This is very hard to do right??

 

[Raphiuz]

can i send the file to you by e-mail or other way?

 

[cyrilbrd]

Hi,
Please confirm:

It should start with file "English Controlo di†rio de tempos_teste.xls" sheet "Diary entries", this will be accessible by the employee, he'll update the file then click the button (VBA) that will send the data as follows:

1) the data from file "English Controlo di†rio de tempos_teste.xls" sheet "Diary entries" will be copied onto "English Controlo di†rio de tempos_teste.xls" sheet "Diary resume" which in turn will be copied onto file "database_teste.xls" sheet "diary data", the information shouldn't be overwritten but rather be placed one under the other.

2) then the sheet "Total data by project" (that is in file"database_teste.xls") should be dynamically updated, it will be like a resume of what is in "diary data" except that it will summarize all information per code D01, D02...

Is this correct?