# TIMESHEET

#### YARNOS

##### New Member
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!!!!!!!

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
On 2002-09-17 01:33, YARNOS wrote:
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!!!!!!!

Replies
1
Views
491
Replies
1
Views
404
Replies
2
Views
109
Replies
14
Views
359
Replies
0
Views
149

1,203,146
Messages
6,053,755
Members
444,681
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back