Time Formula
 

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

Time Formula
 

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

Time Formula
 

What does INT represent

"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

Time Formula
 

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

Time Formula
 

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 -

Time Formula
 

Did you look it up in Help?

In article ,
Jessica wrote:

What does MOD mean?

Time Formula
 

If i need to know how many remaining minutes does column A have, what can i
add to the below formula?

"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

Time Formula
 

Don't add anything at all. Use the second formula that Ron gave you.
--
David Biddulph

"Jessica" wrote in message
...
If i need to know how many remaining minutes does column A have, what can
i
add to the below formula?

"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

Time Formula
 

On Wed, 27 Feb 2008 07:05:01 -0800, Jessica
wrote:

What does INT represent


INT is one of Excel's built-in functions.

Look at HELP for INT Worksheet function.
--ron

Time Formula
 

On Wed, 27 Feb 2008 07:11:01 -0800, Jessica
wrote:

What does MOD mean?


MOD is one of Excel's built-in functions.

Look at HELP for MOD Worksheet function.
--ron

Time Formula
 

On Wed, 27 Feb 2008 07:39:01 -0800, Jessica
wrote:

If i need to know how many remaining minutes does column A have, what can i
add to the below formula?


Didn't the formulas I gave you do that????

Especially: =MOD(SUM(A:A),60)
--ron