[Yr7-10it] Excel query

[Tony Forster]

sorry
will display 1:34 (hh:mm format)
if you want decimal its I think 24*(h4-d4) with a decimal format display
  ----- Original Message ----- 
  From: Tony Forster 
  To: Year 7 - 10 Information Technology Teachers' Mailing List 
  Sent: Thursday, April 27, 2006 1:22 PM
  Subject: Re: [Yr7-10it] Excel query


  =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

  _______________________________________________ 
  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

_____________________________________________________
This mail has been virus scanned by Australia On Line
see http://www.australiaonline.net.au/mailscanning




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


  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/ef6a3879/attachment.html