It would be quicker if you looked these things up in Excel Help.
INT( ) is a function which returns the integer value of a number, so
if you have 3.64 in cell A1, then INT(A1) will return 3 by truncating
the decimal values. See if you can find MOD in Excel Help.

Pete

On Feb 27, 3:11*pm, Jessica wrote:
What does MOD mean?



"Ron Rosenfeld" wrote:
On Wed, 27 Feb 2008 06:17:00 -0800, Jessica
wrote:

I have Column A (Total time in Minutes) and column B (total time in hours).
If column A is more then 60 minutes i would like it to add an hour to column
B. I hope i'm explaining my self correctly

=SUM(B:B)+INT(SUM(A:A)/60)

If you want to also subtract the whole hours from column A, then:

=MOD(SUM(A:A),60)
--ron- Hide quoted text -

- Show quoted text -