Home > Forum Home > Excel Project Management Template > I HAVE NEED OF SOME KNOW HOW... Share

I HAVE NEED OF SOME KNOW HOW...

Excel Help for I Have Need Of Some Know How... in Excel Project Management Template


Forum TopicPost Reply Login

I Have Need Of Some Know How...

Rate this:
(4.3/5 from 3 votes)
ConfusedIN 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 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