[Yr7-10it] Excel query

[Tony Forster]

=h5-d5
it will display 1.34
the cell format defaults to whatever time/date format the source cells are
  ----- Original Message ----- 
  From: Diane Peat 
  To: Yr7-10It 
  Sent: Thursday, April 27, 2006 1:08 PM
  Subject: [Yr7-10it] Excel query


  Hello everyone

  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.

   

  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???

   

  Thanks . anybody!

  Diane Peat

  Firbank Grammar School

  BRIGHTON   VIC   3186

  Phone  9591 5188

  Email dpeat at firbank.vic.edu.au 


  _______________________________________________ 
  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
  Year 7 - 10 IT Mailing List kindly supported by 
  http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and 
  http://www.vitta.org.au - VITTA Victorian Information Technology Teachers Association Inc 


------------------------------------------------------------------------------


  No virus found in this incoming message.
  Checked by AVG Free Edition.
  Version: 7.1.385 / Virus Database: 268.5.0/325 - Release Date: 26/04/2006
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/yr7-10it/attachments/20060427/2d098779/attachment-0001.html