Date: 5/27/2015 Day: Wednesday WotY: 22 Date for the Day Day of the Week Clock In Clock out Amount Monday 7:00 AM 3:00 PM 8.00 Tuesday 7:00 AM 25.00 Wednesday 25.00 Thursday 7:00 AM 3:00 PM 33.00 Friday 7:00 AM 3:00 PM 41.00 Saturaday 7:00 AM 3:00 PM 49.00 Sunday 7:00 AM 3:00 PM 57.00 Total Time: 57.00 OverTime: 17.00 Holiday Hours: Ok so my first question...In Column A beside the list of the day of the week I want the date for that day for that week and when the week changes i want it to change to the next week. Next question...Under Overtime Hours I have Holiday Hours and I want to be able for it to automatically calculate the amount of holiday hours.....

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Multiple Questions...Please and help if you can

Thread starter DHG BamaBlood94
Start date May 27, 2015

DHG BamaBlood94

Board Regular

May 27, 2015

Date:	5/27/2015
Day:	Wednesday
WotY:	22

Date for the Day	Day of the Week	Clock In	Clock out	Amount
	Monday	7:00 AM	3:00 PM	8.00
	Tuesday	7:00 AM		25.00
	Wednesday			25.00
	Thursday	7:00 AM	3:00 PM	33.00
	Friday	7:00 AM	3:00 PM	41.00
	Saturaday	7:00 AM	3:00 PM	49.00
	Sunday	7:00 AM	3:00 PM	57.00
			Total Time:	57.00
			OverTime:	17.00
			Holiday Hours:

Ok so my first question...In Column A beside the list of the day of the week I want the date for that day for that week and when the week changes i want it to change to the next week.

Next question...Under Overtime Hours I have Holiday Hours and I want to be able for it to automatically calculate the amount of holiday hours.....