Home > Forum Home > Excel Project Management Template > I HAVE NEED OF SOME KNOW HOW... | Share |
Forum Topic | Post Reply Login |
I Have Need Of Some Know How... | Rate this: (4.3/5 from 3 votes) |
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 | ||
Posted by WERNER SLABBERT on |
There are currently no replies to the "I HAVE NEED OF SOME KNOW HOW..." topic of the Excel Help Forum for Excel Project Management Template. Post Reply |
Find relevant Excel templates and add-ins for I HAVE NEED OF SOME KNOW HOW... in the Excel Business Solutions Directory |