How To Add Time In Excel Or Numbers
June 19th, 2009
This one had me going for a while the other day. I had a cell with a time in it, and just wanted to add 15 minutes to it and place it in the cell next to it. Anyway, the way to do this is to add (or subtract) #Minutes/1440.
For example, if cell A1 has the time 6:15 in it, and you want to add 15 minutes to it for cell A2 simply set it =A1+(15/1440).
The reason for this is that Excel (and Numbers, and.. most likely any other spreadsheet software out there) keeps track of dates, not time – so if you have a date of 6/19/2009, and in the next cell you want 6/20/2009 – you add 1. Well, there are 1440 minutes in a day, so you simply have to add a fraction of a day equal to the amount of time you want to add. So 15/1440 = 0.0104166667 days.
Jonathan, you just saved me so much grief! I do a lot of work with spreadsheets but I’d never had to do this. I’m putting together a ‘run order’ for a client event and I couldn’t believe how hard it was to get Numbers to do this. Many thanks.
Thanks for sharing that, saved me time in searching through functions, etc.
I’m trying to make a spreadsheet that adds up the running time of songs. I’m a DJ and I’m getting a volunteer radio show, so I’d like to type in my song selections and see how long the show would be. I’m new to the Mac and I’m using Numbers. Thanks.
Hey Brian. Did you figure this out? BTW, if you are using iTunes, it will tell you the length of a playlist at the bottom of the window, that might be an easier way to figure it out.
The easiest way to do this would be to enter the length of the song in in seconds, then at the bottom have a total of all the songs, in seconds. Then you can set a cell to be (#seconds/60) to find out how many minutes it would be.
Thanks Jonathan!
It’s always the formulas I think would be easy that get me…
Best Regards.