Dark Hours

[juiceview]

Hi, see if you can help me here.
I get paid extra for "dark hours"
criteria:
Whatever hours I work after 6:00pm, Monday's through Friday's
Whatever hours I work after 1:00pm on Saturday's
Whatever hours I work after 7:00am on Sunday's (yes AM)
Now I want to make a formula for this scenario so it is easier for my boss to calulate and pay me whenever I have to print my time sheet.
Thanks for the help!

This is what my timesheet looks like:
<TABLE style="WIDTH: 178pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=236 x:str><COLGROUP><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4315" span=2 width=118><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 89pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl17 height=17 width=118 align=right x:num="40717.586111111108">6/23/2011 14:04</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 89pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl17 width=118 align=right x:num="40717.888888888891">6/23/2011 21:20</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl17 height=17 align=right x:num="40718.580555555556">6/24/2011 13:56</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl17 align=right x:num="40718.918055555558">6/24/2011 22:02</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl17 height=17 align=right x:num="40719.5">6/25/2011 12:00</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl17 align=right x:num="40719.883333333331">6/25/2011 21:12</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl17 height=17 align=right x:num="40720.285416666666">6/26/2011 6:51</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl17 align=right x:num="40720.545138888891">6/26/2011 13:05</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl17 height=17 align=right x:num="40721.28125">6/27/2011 6:45</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl17 align=right x:num="40721.775000000001">6/27/2011 18:36</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl17 height=17 align=right x:num="40722.284722222219">6/28/2011 6:50</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl17 align=right x:num="40722.791666666664">6/28/2011 19:00</TD></TR></TBODY></TABLE>

 

[Greg Truby]

Welcome to the board. You can use the WEEKDAY() function to determine what day of the week it is. I'm assuming the clock resets at midnight and you're time-out will always fall on the same day as the time in.

Excel Workbook
	A	B	C	D	E	F
1	Time In	Time Out	Time Worked	M-F	Sat	Sun
2	Thu 6/23/2011 14:04	Thu 6/23/2011 21:20	7:16	3:20	0:00
3	Fri 6/24/2011 13:56	Fri 6/24/2011 22:02	8:06	4:02	0:00
4	Sat 6/25/2011 12:00	Sat 6/25/2011 21:12	9:12	0:00	8:12
5	Sun 6/26/2011 6:51	Sun 6/26/2011 13:05	6:14	0:00	0:00
6	Mon 6/27/2011 6:45	Mon 6/27/2011 18:36	11:51	0:36	0:00
7	Tue 6/28/2011 6:50	Tue 6/28/2011 19:00	12:10	1:00	0:00
Sheet4

I'm a "teach them to fish", not a "just give them fish" kinda guy, so I shall leave it for you to apply the above to figure out Sunday.