I ran across this OLD thread while researching a problem and hoped you could expand just a bit.
I am trying to add hours and minutes, just as above. However, I report everything in fifteen minute increments.
Example: 1.15 = one hour fifteen minutes
1.30 = one hour thirty minutes
When I add as you suggested, I get 165 minutes / 60 = 2.75 hours. I need this answer to display as 2.45 (two hours and 45 minutes). If I add these with normal math, the above problem works correctly, but the answer doesn't compute correctly with other time variables:
Example: 1.30 + 1.30 = 2.60 instead of 2 hours.
any ideas on how I can add these in 15 minute increments?