WERNER SLABBERT
Board Regular
- Joined
- Mar 3, 2009
- Messages
- 104
In a project i am compiling i need to work accurately with times to calculate the work progress of the people in the workshop thus....here goes....
I have in work book #1 (7) sheets mon to fri + complete week + a sheet where all job numbers are collected.
From monday to friday the workmen log their times as a start time and a end time. This has to be then calculated to a total hours:mins spent per job, wich in turn then has to be calculated to a total hours:mins spent per day. And the on the complete week sheet recalculated as a total time worked per week.
Any help would be welcome as to how these formulae have to be written.
Ps: I do'nt know how to wright macros.
Then this workbook needs to link to a master book wich will be on another machine where the boss man can check stats for about 85 people ( 85 above mentioned workbooks. )
please please please can any one help??????
Wjslab
I have in work book #1 (7) sheets mon to fri + complete week + a sheet where all job numbers are collected.
From monday to friday the workmen log their times as a start time and a end time. This has to be then calculated to a total hours:mins spent per job, wich in turn then has to be calculated to a total hours:mins spent per day. And the on the complete week sheet recalculated as a total time worked per week.
Any help would be welcome as to how these formulae have to be written.
Ps: I do'nt know how to wright macros.
Then this workbook needs to link to a master book wich will be on another machine where the boss man can check stats for about 85 people ( 85 above mentioned workbooks. )
please please please can any one help??????
Wjslab
Last edited by a moderator:
