Weekly Time-sheet Calculator

[whalley_uk]

Hi Guys a new member and post so please go easy if this has been asked before.

I organise some timesheets for a company i work for and need an easier way to input the hours etc
i currently use a printed version of this picture below.

My Questions are :

i would like to make an excel file where i can input a date in the week commensing and it will translate to putting an acctual date below each of the days

i dont mind manually inputting a month in the month title but is there a formula that can automatically insert the last friday date into the paying date that would corrospond with that month ?

also i input hours into each time slot for the person and date, i know we could make a simple sum to add all the times up but also can i make one where once it reaches 40 hours it will the put the remainder into the total overtime.


Any help would be highly appreciated and if anyone would like to e-mail me personally my e-mail is

awhalley@fheltd.co.uk

 

[AhoyNC]

Maybe something like this.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1
2	Week comm.	7/8/2016				Last Fri	in month	7/29/2016
3		Fri	Sat	Sun	Mon	Tue	Wed	Thu	Reg.	Overtime
4	Employee	7/8/2016	7/9/2016	7/10/2016	7/11/2016	7/12/2016	7/13/2016	7/14/2016	Hours	Hours
5	Neil	8	0	8	10	7	4	8	40	5
6
Sheet