 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2005Bachelor cooking Xmas dinner !
In Excel 2000, I want to create a spreadsheet which has a column of foods, a column of cooking times (in minutes), and a third column which calculates the time to begin cooking that item based on an inserted mealtime. For instance, if a mealtime of 2:00 pm is inserted manually then the row for "Beef Joint - 90 mins" would return 12:30 pm in the third column; and the row "Carrots - 30 mins" would return 1:30 pm in the third column. I think the answer is in the formatting but I cannot make it work! NOT Gordon Ramsey. Graham, If what you are asking is how do you subtract an integer in say B2 like 90 from a time like 14:00 in C1 then try: =$C$1-(B2/60/24) and format column C as time  SignatureHTH Sandy sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk > In Excel 2000, I want to create a spreadsheet which has a column of foods, > a column of cooking times (in minutes), and a third column which [quoted text clipped - 5 lines] > work! > NOT Gordon Ramsey. Belated thanks Sandy (Virus problems with Trojan Adclickers prevented an earlier reply.) Happy New Year, Graham B > Graham, > [quoted text clipped - 14 lines] >> make it work! >> NOT Gordon Ramsey. You're welcome Graham, glad that you got the dinner, trojan & your spreadsheet all sorted out. SignatureRegards Sandy sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk > Belated thanks Sandy (Virus problems with Trojan Adclickers prevented an > earlier reply.) [quoted text clipped - 19 lines] >>> make it work! >>> NOT Gordon Ramsey. There's also a sample dinner planner on my web site, that may help you: http://www.contextures.com/excelfiles.html Under Data Validation, look for Cooking Time Planner > Belated thanks Sandy (Virus problems with Trojan Adclickers prevented an > earlier reply.) [quoted text clipped - 19 lines] >>>make it work! >>>NOT Gordon Ramsey. SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.