1 Reply Latest reply: Jul 19, 2011 7:46 AM by Claudia Zwick RSS

    hour

      hi

       

      pls explain the below

       

      =hour( ' 0.5555 ' ) returns 13 (because 0.5555 =13:19:55)

       

       

       

      rgds

      karthika

        • hour

          Hi karthika,

           

          I don't know, what for a explanation you want to have, but:

           

          A day has 24 hours and 24 * 0.5555 = 13,332, so hour ('0.5555') returns 13.

           

          Or: 0.5555 = '13:19:55'

          So, the hour is 13 => hour('0.5555') returns 13

          the minute is 19 => minute('0.5555') returns 19

          and the second is 55 => second ('0.5555') returns 55

           

          Regards vicky