need fraction of hour display?

I am not getting my time difference in fraction of hours in proper way. Eg :8/01/2009 08:00 AM to 8/02/2009 07:30 AM difference showing after applying the formula =((L2-D2)*1440) / 60 is 23:50 hours instead of 23:30 hrs.I want 23:30 hours .Please give a solution.

2 Answers

  • 1 decade ago
    Favorite Answer


    When you find 23h50, it means 23.5 hours.

    0.5 hours is 30 minutes !

    Therefore it is 23h 30'

    And your answer was right

    Hope it helped

    Bye !

  • Anonymous
    1 decade ago

    That's because there are 60 minutes in an hour, not 100. So 23.5 hours, or rather 23 1/2 hours is the correct "fraction of hours".

    Separate the whole number of hours from the fractional (or decimal) part of the hours, and multiply that fractional part by 60. That gives you the number of minutes. For example, 15.25 hours is 15 hours plus 0.25 hours, or 15 hours and 0.25*60= 15 minutes.

Still have questions? Get your answers by asking now.