logic question/formula needed

[bestdad]

Ok I have the formula to go one way. but the company would like the information be inputed into the worksheet in reverse order.

Working on work schedule for employees. The supervisor will fill out a schedule based off of a start time and end time from Sunday to Saturday. Basically I was thinking of a drop down box with validation for this section. This is the easy part.
Sheet 1
Example:
Sunday
Time In 8:00
Time Out 10:00
Tot hrs: 2

Sheet 2 I want to have it auto filled in based off of sheet 1.
Sheet 2 See below

<TABLE style="WIDTH: 1002pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1334><COLGROUP><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1280" width=35><COL style="WIDTH: 107pt; mso-width-source: userset; mso-width-alt: 5193" width=142><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" span=3 width=63><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width=57><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" width=55><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 2048" width=56><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1974" width=54><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 2048" width=56><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" width=55><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" span=2 width=57><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" width=63><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1974" width=54><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3620" width=99><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 26pt; HEIGHT: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 height=40 rowSpan=2 width=35>[FONT=Calibri]ID[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 107pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69 rowSpan=2 width=142>[FONT=Calibri]Name[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 rowSpan=2 width=64>[FONT=Calibri]Time In[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 rowSpan=2 width=64>[FONT=Calibri]Time Out[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 44pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=58>[FONT=Calibri]8:00 AM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 46pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=61>[FONT=Calibri]9:00 AM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 47pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=63>[FONT=Calibri]10:00 AM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 47pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=63>[FONT=Calibri]11:00 AM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 47pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=63>[FONT=Calibri]12:00 PM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 44pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=58>[FONT=Calibri]1:00 PM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 43pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=57>[FONT=Calibri]2:00 PM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 41pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=55>[FONT=Calibri]3:00 PM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 42pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=56>[FONT=Calibri]4:00 PM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 41pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=54>[FONT=Calibri]5:00 PM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 42pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=56>[FONT=Calibri]6:00 PM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 41pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=55>[FONT=Calibri]7:00 PM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 43pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=57>[FONT=Calibri]8:00 PM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 43pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=57>[FONT=Calibri]9:00 PM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 47pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 rowSpan=2 width=63>[FONT=Calibri]10:00 PM[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 41pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 rowSpan=2 width=54>[FONT=Calibri]Tot Hrs[/FONT]</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 74pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 rowSpan=2 width=99>[FONT=Calibri]Employee Cost[/FONT]</TD></TR><TR style="HEIGHT: 15pt" height=20></TR></TBODY></TABLE>

from tot hrs calculated I want it to start at 8:00 Am and put a 1, then goto 9 am put a 1, and 10am and put a 1. So as time in and time out changes per employee so does this page. This helps them see any time of the day they might have a hole in there schedule.

**** Change when they start at 8:30 or get off at 10:30 I guess instead of 1 it should be .5. So all calculations are correct. ******

Thanks for any help or ideas. This requst has been driving me crazy lol

 

[Gerald Higgins]

Well to start with, if they start at 8 and work 2 hours, wouldn't you have a zero or blank under 10, not 1 ?

 

[bestdad]

Well to start with, if they start at 8 and work 2 hours, wouldn't you have a zero or blank under 10, not 1 ?

Can you please explain your two lines of code. I am sure you want me to stick into VBA and not into a cell from what I can find out. But after the Reference is where i got lost. I am sorry this is a new concept never used this code before. Thanks ahead of time

 

[Gerald Higgins]

Please read the small print above the code . . .

 

[bestdad]

Please read the small print above the code . . .

lol i feel so stupid now

 

[bestdad]

Well to start with, if they start at 8 and work 2 hours, wouldn't you have a zero or blank under 10, not 1 ?

yes you are right i made a mistake on that