You are here:

Excel/adding time in an excel spreadsheet



Basically I want to learn how to add some times for a schedule I m preparing.  So if the events begin at 8:00 and the first event takes 12 minutes I want to return an answer that will say the new time is 8:12.  Then the next event takes 5 minutes so the new time should read 8:17,  then the third event...I think you get the picture.  I am thinking of just setting the time for these various events in some cells at one corner of the spreadsheet and then just refer to them when I need them.  So if E1= 12 minutes and E2= 5 minutes and I started the program at 8:00 then 8:00 + A1 + A2 would equal 8:17.  I would then cycle around to the second line in my spreadsheet only now the time is 8:17 and 8:17 + A1 + A2 = 8:34.  This a bit of a simplification as there are 5 or 6 times that would be A3, 4, A5, etc. but you get the idea.  Hopefully you can show me how to use some of the Excel TIME functions to work this out.

A minute is 1/1440 of a day in Excel time calculations.  If you had a time in A3 of 8:00am and a value of 5 in B1 to represent 5 minutes, you could see the new time with this formula in B3:


See the attached picture, that formula is copied across to the right to get the continuing calculations.   This should give you the idea and you can adapt for your own actual layout.  
About Excel


All Answers

Answers by Expert:

Ask Experts


Jerry Beaucaire





Bachelor's Degree from Azusa Pacific University in Mathematics and Music Composition

Awards and Honors
Microsoft Excel MVP 2010

©2016 All rights reserved.