Avatar

Level 4

Paul,

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?

thanks!

Gene-O