If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Bachelor 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. |
#2
|
|||
|
|||
Bachelor cooking Xmas dinner !
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 -- HTH Sandy with @tiscali.co.uk "Graham B." wrote in message ... 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. |
#3
|
|||
|
|||
Bachelor cooking Xmas dinner !
Belated thanks Sandy (Virus problems with Trojan Adclickers prevented an
earlier reply.) Happy New Year, Graham B "Sandy Mann" wrote in message ... 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 -- HTH Sandy with @tiscali.co.uk "Graham B." wrote in message ... 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. |
#5
|
|||
|
|||
Bachelor cooking Xmas dinner !
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 Graham B. wrote: Belated thanks Sandy (Virus problems with Trojan Adclickers prevented an earlier reply.) Happy New Year, Graham B "Sandy Mann" wrote in message ... 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 -- HTH Sandy with @tiscali.co.uk "Graham B." wrote in message ... 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Where do I find Xmas stationery for OUtlook | Liz B | General Discussion | 4 | December 15th, 2005 11:04 PM |
Xmas Card Mailing List? | Reading Teacher | General Discussion | 2 | December 11th, 2005 11:56 AM |
make address labels for xmas cards, save as word doc | waveydavey | General Discussion | 3 | December 9th, 2005 06:29 AM |
xmas greeting card | rhiannahm | General Discussion | 2 | December 2nd, 2005 01:12 AM |
I Know it's Xmas BUT....... DLookup problem | Tony Williams | Setting Up & Running Reports | 6 | December 28th, 2004 07:13 PM |