minutes

D

Delbert

I have a spreadsheet that I would like to add up my minutes. So I have one
column that has 4:20 and the next column that has 4:40, how do I get the next
column to add up the minutes (15 minutes)?

Thank you
 
B

Bob I

Add up what minutes? You seem to have 20 minutes after 4 o'clock in one
column and 40 minutes after 4 o'clock in the other. Just what "minutes"
are you wanting to add, and how did you come up with 15?
 
J

Jim Thomlinson

Not sure if 4:20 is 4 min 20 sec or 4 hrs 20 min but in either case create a
regular addition formula such as =A2 + B2 referencing the time cells. Now
change the format of the cell with the formula to a custom format of [m]:ss
The square brackets will keep the formula from incrmenting into hours after
60 minutes has been reached.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top