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.
- Good guyLv 71 decade agoFavorite 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
- Anonymous1 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.