Time Formula

J

Jessica

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
 
R

Ron Rosenfeld

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
Click to expand...



=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
 
J

Jessica

What does INT represent

Ron Rosenfeld said:
=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
Click to expand...
 
J

Jessica

What does MOD mean?

Ron Rosenfeld said:
=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
Click to expand...
 
P

Pete_UK

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
 
J

Jessica

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

Ron Rosenfeld

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


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

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