Adding hours & minutes

Avatar

Avatar

JillOfAllTrades

Avatar

JillOfAllTrades

JillOfAllTrades

24-02-2011

I am creating a form for staff to enter in the actual hours and minutes that they spend with a client each ses

sion and I cannot figure out how to get the time to add up correctly.  I am looking for minutes not fractions of minutes.

Example: Sarah sat with Joey for 1 hour and 25 minutes and sat with Jill for 30 minutes - must add up as 1:55

I have searched the web many times and can find nothing. Does anyone have any suggestions?

View Entire Topic

Avatar

Avatar

Gene--O

Avatar

Gene--O

Gene--O

11-09-2013

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