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