I HAVE CREATED THE CUSTOM TIME SHEET THAT I REQUIRE THANK YOU TO KKRANZ454!! THANK YOU FOR SUPPORT..Is there any one out there to help create the following solution..
I have created 40 rows to allow for the entire week to be inputed which i then divide the row by 7 to give me an average of 4 jobs per day to be inputed,but what happens you might get a day that you might work long hours and attend to more than 4 jobs.How do i make the sheet to allow my rows and the calculation to all add up
eg:-
monday job1 7.00am 8:00am
job2 8:00am 1:00pm
job3 1:00pm 4:00pm
job4 4:00pm 4:30pm
total hrs 38
Now lets say tues you might do 8 jobs you are limited to enter the rest of the 4 jobs
unless you run into the next day....
Does any body have any directions if so write to me!!!!!!!
I can email the timesheet if you require more info!!!
I have created 40 rows to allow for the entire week to be inputed which i then divide the row by 7 to give me an average of 4 jobs per day to be inputed,but what happens you might get a day that you might work long hours and attend to more than 4 jobs.How do i make the sheet to allow my rows and the calculation to all add up
eg:-
monday job1 7.00am 8:00am
job2 8:00am 1:00pm
job3 1:00pm 4:00pm
job4 4:00pm 4:30pm
total hrs 38
Now lets say tues you might do 8 jobs you are limited to enter the rest of the 4 jobs
unless you run into the next day....
Does any body have any directions if so write to me!!!!!!!
I can email the timesheet if you require more info!!!
