Time Formula

[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

 

[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

=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

 

[Jessica]

What does INT represent

=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

 

[Jessica]

What does MOD mean?

=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

 

[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

 

[JE McGimpsey]

Did you look it up in Help?

 

[Jessica]

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

 

[David Biddulph]

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

 

[Ron Rosenfeld]

What does INT represent

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

Look at HELP for INT Worksheet function.
--ron

 

[Ron Rosenfeld]

What does MOD mean?

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

Look at HELP for MOD Worksheet function.
--ron

 

[Ron Rosenfeld]

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