You are here:

- Home
- Computing/Technology
- Business Software
- Excel
- adding time in an excel spreadsheet

Advertisement

Hi:

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:

=A3+(B1/1440)

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.

- Add to this Answer
- Ask a Question

Rating(1-10) | Knowledgeability = 10 | Clarity of Response = 10 | Politeness = 10 |

Comment | Great. Thanks for your answer. |

This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

Answers by Expert:

Excel Formulas, macros, automation. Microsoft Excel MVP - 2010. Code site with free code snippets and techniques: http://sites.madrocketscientist.com/jerrybeaucaires-excelassistant/files

Microsoft Excel MVP - 2010. I have my own extensive Excel help/code site: http://sites.madrocketscientist.com/jerrybeaucaires-excelassistant/files
=====================
I have been offering free assistance as an Excel aid on many web sites for many years:
(http://www.excelforum.com - JBeaucaire) ======== (http://www.askmehelpdesk.com/spreadsheets - JBeaucaire) ======= (http://www.mrexcel.com/forum - jbeaucaire)**Education/Credentials**

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

Microsoft Excel MVP 2010