May 2015 model

Discussion in 'CA2' started by DanielZ, Oct 27, 2015.

  1. DanielZ

    DanielZ Member

    Hi all

    I don't understand the use of the "hour unit of time" in the "Minister triathlon" tab of the model solution, cell G12. Why is the formula "=Hour/(D12/Swim_1)" ?

    I understand that time = distance / speed.

    >> EDIT: I think I understand it now. Whenever you work with time values in Excel you need to convert them to "numeric" values using the above method.
     
    Last edited by a moderator: Oct 27, 2015
    DanielZ, Oct 27, 2015
    #1
  2. Steve Hales

    Steve Hales ActEd Tutor Staff Member

    A self-answering thread. Excellent :)
     
    Steve Hales, Oct 29, 2015
    #2
  3. DanielZ

    DanielZ Member

    Thanks Steve!

    I haven't worked much with time values in Excel which was the initial source of confusion. When I realised they are just stored as a fraction out of 24 that made it much clearer.
     
    DanielZ, Oct 29, 2015
    #3

Share This Page