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