Need the right Formula

G

ggwynn

New Member
Joined
Mar 17, 2011
Messages
10
i'm having troubles with the if function of excel and already spent many hours but still no positive result,i want to make a record of my overtimes daily,what is the right formula in excel,the conditions are as follow:

Monday to Friday(total work hours-8= overtime)
Saturday(total work hours-4= Overtime)
Sunday(total work hours=overtime)
please help.thank you
 
Sort by date Sort by votes
Untitled.jpg

i hope this works..
 
Upvote 0

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
To help you visualise my suggestion.

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 75px"><COL style="WIDTH: 35px"><COL style="WIDTH: 14px"><COL style="WIDTH: 14px"><COL style="WIDTH: 14px"><COL style="WIDTH: 14px"><COL style="WIDTH: 14px"><COL style="WIDTH: 14px"><COL style="WIDTH: 14px"><COL style="WIDTH: 14px"><COL style="WIDTH: 14px"><COL style="WIDTH: 14px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 21px"><COL style="WIDTH: 25px"><COL style="WIDTH: 28px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD><TD>P</TD><TD>Q</TD><TD>R</TD><TD>S</TD><TD>T</TD><TD>U</TD><TD>V</TD><TD>W</TD><TD>X</TD><TD>Y</TD><TD>Z</TD><TD>AA</TD><TD>AB</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD>Date</TD><TD>Day</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">12</TD><TD style="TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">14</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">16</TD><TD style="TEXT-ALIGN: right">17</TD><TD style="TEXT-ALIGN: right">18</TD><TD style="TEXT-ALIGN: right">19</TD><TD style="TEXT-ALIGN: right">20</TD><TD style="TEXT-ALIGN: right">21</TD><TD style="TEXT-ALIGN: right">22</TD><TD style="TEXT-ALIGN: right">23</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right">01/01/2011</TD><TD style="TEXT-ALIGN: right">Sat</TD><TD> </TD><TD> </TD><TD> </TD><TD>/</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>\</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">9.0</TD><TD style="TEXT-ALIGN: right">5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right">02/01/2011</TD><TD style="TEXT-ALIGN: right">Sun</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>/</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>\</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">5.0</TD><TD style="TEXT-ALIGN: right">5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right">03/01/2011</TD><TD style="TEXT-ALIGN: right">Mon</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>/</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>\</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">8.0</TD><TD style="TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">04/01/2011</TD><TD style="TEXT-ALIGN: right">Tue</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>x</TD><TD>\</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">8.5</TD><TD style="TEXT-ALIGN: right">0.5</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>AA2</TD><TD>=COUNTIF(C2:Z2,"X")+(COUNTIF(C2:Z2,"\")+COUNTIF(C2:Z2,"/"))/2</TD></TR><TR><TD>AB2</TD><TD>=MAX(0,AA2-LOOKUP(WEEKDAY(A2,3),{0,5,6},{8,4,0}))</TD></TR><TR><TD>AA3</TD><TD>=COUNTIF(C3:Z3,"X")+(COUNTIF(C3:Z3,"\")+COUNTIF(C3:Z3,"/"))/2</TD></TR><TR><TD>AB3</TD><TD>=MAX(0,AA3-LOOKUP(WEEKDAY(A3,3),{0,5,6},{8,4,0}))</TD></TR><TR><TD>AA4</TD><TD>=COUNTIF(C4:Z4,"X")+(COUNTIF(C4:Z4,"\")+COUNTIF(C4:Z4,"/"))/2</TD></TR><TR><TD>AB4</TD><TD>=MAX(0,AA4-LOOKUP(WEEKDAY(A4,3),{0,5,6},{8,4,0}))</TD></TR><TR><TD>AA5</TD><TD>=COUNTIF(C5:Z5,"X")+(COUNTIF(C5:Z5,"\")+COUNTIF(C5:Z5,"/"))/2</TD></TR><TR><TD>AB5</TD><TD>=MAX(0,AA5-LOOKUP(WEEKDAY(A5,3),{0,5,6},{8,4,0}))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
 
Upvote 0
=IF(AA7>4,ABS(AA7-4),0)saturday
=IF(AA8>0,ABS(AA8-0),0)sunday
=IF(AA9>8,ABS(AA9-8),0)weekday
maybe if you use 1's and .5

I say keep it simple.
 
Last edited:
Upvote 0
is there a way to make it into a single formula?,like nesting if formula?well thanks anyways,,appreciate it
 
Upvote 0
i would really love to make it simple,but i have to follow a format
"/" if I worked for the first half hour
"\" if for the second half hour
"X" for the whole hour,,
i'll try to figure it on my own and post it here if i can..thanks guys
 
Upvote 0
ggwynn said:
i would really love to make it simple,but i have to follow a format
"/" if I worked for the first half hour
"\" if for the second half hour
"X" for the whole hour,,
i'll try to figure it on my own and post it here if i can..thanks guys
Click to expand...

What's wrong with the solution that Jasonb75 posted? It does exactly that.
 
Upvote 0
yes it does,but if i do that for march,i will have to readjust the formula to match the days of april,
 
Upvote 0
You mean you want to re-use the same sheet next month, and the month after, etc?

It appears that you have merged A1:Z1 so I've done the same. In that merged cell enter the date 01/03/11 and format as mmmm

Enter the 3 formula as below, then autofill from A5 and B4 down to A34 and B34.

When you change the merged cell to 01/04/11 the formula will change the rest for you.
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 83px"><COL style="WIDTH: 36px"><COL style="WIDTH: 15px"><COL style="WIDTH: 15px"><COL style="WIDTH: 15px"><COL style="WIDTH: 15px"><COL style="WIDTH: 15px"><COL style="WIDTH: 15px"><COL style="WIDTH: 15px"><COL style="WIDTH: 15px"><COL style="WIDTH: 15px"><COL style="WIDTH: 15px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 23px"><COL style="WIDTH: 28px"><COL style="WIDTH: 28px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD><TD>P</TD><TD>Q</TD><TD>R</TD><TD>S</TD><TD>T</TD><TD>U</TD><TD>V</TD><TD>W</TD><TD>X</TD><TD>Y</TD><TD>Z</TD><TD>AA</TD><TD>AB</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: center" colSpan=26>March</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Date</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Day</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">1</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">2</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">3</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">4</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">5</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">6</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">7</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">8</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">9</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">10</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">12</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">13</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">14</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">15</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">17</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">18</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">19</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">20</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">21</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">22</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">23</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">01/03/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Tue</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">/</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">\</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">9</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">02/03/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Wed</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">/</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">\</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">5</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">03/03/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Thu</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">/</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">\</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">8</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">0</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">04/03/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Fri</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">x</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">\</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">9</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">1</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>A4</TD><TD>=A1</TD></TR><TR><TD>B4</TD><TD>=A4</TD></TR><TR><TD>A5</TD><TD>=A4+1</TD></TR><TR><TD></TD><TD></TD></TR><TR><TD></TD><TD></TD></TR><TR><TD></TD><TD></TD></TR><TR><TD></TD><TD></TD></TR><TR><TD></TD><TD></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

If there is any part of it you're not sure of, I've uploaded the sheet for you to try

http://download1072.mediafire.com/h3jhh0zsy7lg/zrcqllqyxev5q7j/ggwynn.xlsm
 
Upvote 0
well i have another question,is there a way to automatically change the color of the cells if it is blank, i mean if i haven't put "/", "\", and "X" on the box?
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question Question
Creating Formulas for timesheets
Replies
2
Views
254
HighAndWilder
H
R
  • Question Question
Time sheet formulas
Replies
2
Views
363
rodnaaaaay
R
J
  • Solved
VBA or Excel – Time sheet with RT / OT based on the day of the week.
Replies
5
Views
665
awoohaw
awoohaw
R
  • Solved
Overtime based on weekends AND holidays
2
Replies
12
Views
887
rockson
R
M
  • Question Question
Spreadsheet to calculate overtime and total hours
Replies
1
Views
1K
HyraxWithAFlamethrower
H

Forum statistics

Threads
1,224,587
Messages
6,179,740
Members
452,940
Latest member
rootytrip

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top