<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content=Word.Document name=ProgId>
<META content="MSHTML 6.00.2900.2873" name=GENERATOR>
<META content="Microsoft Word 9" name=Originator><LINK
href="cid:filelist.xml@01C669FB.B3463B70" rel=File-List><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:ActiveWritingStyle Lang="EN-AU" VendorID="64" DLLVersion="131077"
NLCheck="1">1</w:ActiveWritingStyle>
<w:ActiveWritingStyle Lang="EN-GB" VendorID="64" DLLVersion="131077"
NLCheck="1">1</w:ActiveWritingStyle>
<w:ActiveWritingStyle Lang="EN-US" VendorID="64" DLLVersion="131077"
NLCheck="1">1</w:ActiveWritingStyle>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:DrawingGridHorizontalSpacing>5.5 pt</w:DrawingGridHorizontalSpacing>
<w:DisplayHorizontalDrawingGridEvery>2</w:DisplayHorizontalDrawingGridEvery>
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>
</w:WordDocument>
</xml><![endif]-->
<STYLE>@font-face {
font-family: Footlight MT Light;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 89.85pt 72.0pt 89.85pt; mso-header-margin: 35.45pt; mso-footer-margin: 35.45pt; mso-title-page: yes; mso-header: url("cid:header.htm@01C669FB.B3463B70") h1; mso-footer: url("cid:header.htm@01C669FB.B3463B70") f1; mso-first-header: url("cid:header.htm@01C669FB.B3463B70") fh1; mso-first-footer: url("cid:header.htm@01C669FB.B3463B70") ff1; mso-paper-source: 0; }
P.MsoNormal {
FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; COLOR: #333399; FONT-FAMILY: "Footlight MT Light"; mso-bidi-font-size: 9.0pt; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB
}
LI.MsoNormal {
FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; COLOR: #333399; FONT-FAMILY: "Footlight MT Light"; mso-bidi-font-size: 9.0pt; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB
}
DIV.MsoNormal {
FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; COLOR: #333399; FONT-FAMILY: "Footlight MT Light"; mso-bidi-font-size: 9.0pt; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB
}
P.MsoHeader {
FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; COLOR: #333399; FONT-FAMILY: "Footlight MT Light"; mso-bidi-font-size: 9.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB; tab-stops: center 207.65pt right 415.3pt
}
LI.MsoHeader {
FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; COLOR: #333399; FONT-FAMILY: "Footlight MT Light"; mso-bidi-font-size: 9.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB; tab-stops: center 207.65pt right 415.3pt
}
DIV.MsoHeader {
FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; COLOR: #333399; FONT-FAMILY: "Footlight MT Light"; mso-bidi-font-size: 9.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB; tab-stops: center 207.65pt right 415.3pt
}
P.MsoFooter {
FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; COLOR: #333399; FONT-FAMILY: "Footlight MT Light"; mso-bidi-font-size: 9.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB; tab-stops: center 207.65pt right 415.3pt
}
LI.MsoFooter {
FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; COLOR: #333399; FONT-FAMILY: "Footlight MT Light"; mso-bidi-font-size: 9.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB; tab-stops: center 207.65pt right 415.3pt
}
DIV.MsoFooter {
FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; COLOR: #333399; FONT-FAMILY: "Footlight MT Light"; mso-bidi-font-size: 9.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB; tab-stops: center 207.65pt right 415.3pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
P.MsoAutoSig {
FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; COLOR: #333399; FONT-FAMILY: "Footlight MT Light"; mso-bidi-font-size: 9.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB
}
LI.MsoAutoSig {
FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; COLOR: #333399; FONT-FAMILY: "Footlight MT Light"; mso-bidi-font-size: 9.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB
}
DIV.MsoAutoSig {
FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; COLOR: #333399; FONT-FAMILY: "Footlight MT Light"; mso-bidi-font-size: 9.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB
}
SPAN.EmailStyle18 {
COLOR: black; mso-bidi-font-family: Arial; mso-style-type: personal-compose; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="3074"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1"/>
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-AU style="tab-interval: 36.0pt" vLink=purple link=blue
bgColor=#ffffff>
<DIV><FONT face=Arial size=2>sorry</FONT></DIV>
<DIV><FONT face=Arial size=2>will display 1:34 (hh:mm format)</FONT></DIV>
<DIV><FONT face=Arial size=2>if you want decimal its I think 24*(h4-d4) with a
decimal format display</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=forster@ozonline.com.au href="mailto:forster@ozonline.com.au">Tony
Forster</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=yr7-10it@edulists.com.au
href="mailto:yr7-10it@edulists.com.au">Year 7 - 10 Information Technology
Teachers' Mailing List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, April 27, 2006 1:22
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Yr7-10it] Excel query</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>=h5-d5</FONT></DIV>
<DIV><FONT face=Arial size=2>it will display 1.34</FONT></DIV>
<DIV><FONT face=Arial size=2>the cell format defaults to whatever time/date
format the source cells are</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=dpeat@firbank.vic.edu.au
href="mailto:dpeat@firbank.vic.edu.au">Diane Peat</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=yr7-10it@fhc.vic.edu.au
href="mailto:yr7-10it@fhc.vic.edu.au">Yr7-10It</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, April 27, 2006 1:08
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Yr7-10it] Excel query</DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT><FONT
face=Arial size=2></FONT><FONT face=Arial size=2></FONT><BR></DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN class=EmailStyle18><FONT face=Arial color=black
size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 9.0pt">Hello
everyone<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle18><FONT face=Arial color=black
size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 9.0pt">I’m
hoping someone can help me – I’m using the Bowden/Maguire Practice IT Book 2
and in SS exercise 9 and 11, there is a column that displays the difference
in time between an entry and exit time. For example, entry time 10:41 am (in
cell D5) and exit time 12:15 pm (in Cell H5) = 1.34 hours. However, the
hours for the last column don’t show a formula and I’m trying to get a
formula to display the difference between the exit and entry times. I’ve
used =HOUR(H5-D5) but that gives me a whole hour (1.0) even when I format it
to one or two decimal places.<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle18><FONT face=Arial color=black
size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 9.0pt"><![if !supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle18><FONT face=Arial color=black
size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 9.0pt">Because
I was trying to be super clever (to my downfall!!) I wanted to show the
students how to calculate the differences in time with a formula but alas,
I’m stuck! Is there anyone out there who could help me with a formula
please???<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle18><FONT face=Arial color=black
size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 9.0pt"><![if !supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle18><FONT face=Arial color=black
size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 9.0pt">Thanks
… anybody!<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle18><FONT face=Arial color=black
size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 9.0pt">Diane
Peat<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle18><FONT face=Arial color=black
size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 9.0pt">Firbank
Grammar School<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle18><FONT face=Arial color=black
size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 9.0pt">BRIGHTON<SPAN
style="mso-spacerun: yes"> </SPAN>VIC <SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN>3186<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle18><FONT face=Arial color=black
size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 9.0pt">Phone<SPAN
style="mso-spacerun: yes"> </SPAN>9591
5188<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle18><FONT face=Arial color=black
size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 9.0pt">Email
<A href="mailto:dpeat@firbank.vic.edu.au">dpeat@firbank.vic.edu.au</A> <BR
style="PAGE-BREAK-BEFORE: always; mso-special-character: line-break"
clear=all><o:p></o:p></SPAN></FONT></SPAN></P></DIV>_______________________________________________
<BR><A href="http://www.edulists.com.au">http://www.edulists.com.au </A>-
FAQ, resources, subscribe, unsubscribe <BR>Year 7 - 10 IT Mailing List
kindly supported by <BR><A
href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au </A>- Victorian
Curriculum and Assessment Authority and <BR><A
href="http://www.vitta.org.au">http://www.vitta.org.au </A>- VITTA Victorian
Information Technology Teachers Association Inc
<P>
<HR>
<P></P>No virus found in this incoming message.<BR>Checked by AVG Free
Edition.<BR>Version: 7.1.385 / Virus Database: 268.5.0/325 - Release Date:
26/04/2006<BR></BLOCKQUOTE>_______________________________________________
<BR><A href="http://www.edulists.com.au">http://www.edulists.com.au </A>- FAQ,
resources, subscribe, unsubscribe <BR>Year 7 - 10 IT Mailing List kindly
supported by <BR><A
href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au </A>- Victorian
Curriculum and Assessment Authority and <BR><A
href="http://www.vitta.org.au">http://www.vitta.org.au </A>- VITTA Victorian
Information Technology Teachers Association Inc<BR><PRE>_____________________________________________________
This mail has been virus scanned by Australia On Line
see http://www.australiaonline.net.au/mailscanning
</PRE><BR>
<P>
<HR>
<P></P>No virus found in this incoming message.<BR>Checked by AVG Free
Edition.<BR>Version: 7.1.385 / Virus Database: 268.5.0/325 - Release Date:
26/04/2006<BR></BLOCKQUOTE></BODY></HTML>