How do I format and add minutes together ie. 3:35 and 4:47 correc.

A

Alan

I am trying to add minutes and seconds together. How do I format these times
correctly and then how do I add them together ie. 3.35 and 4.47 should give
me 8:22. Got me stumped. I am using a textbox with =sum(Time) the answers are
not right. I am using short time. I have used [m]:ss that is wrong also. Any
help would be appreiciated
 
L

Larry Daugherty

Hi Alan,

It's always tougher or simpler than you'd think. Start every operation by
converting things into the smallest unit of measure; seconds in this case,
and do all of your math in seconds. On the way out you then divide the
seconds by the next higher unit of measure, etc.

HTH
 
Top