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

[Guest]

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

 

[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

 

[onedaywhen]

Start every operation by
converting things into the smallest unit of measure; seconds in this case,
and do all of your math in seconds.

I think it would be better to convert the values to the correct data
type, i.e. DATETIME for Jet or Date for VBA, rather than convert to
INTEGER/Integer.

Jamie.

--