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.

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
sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"Graham B." <bertiegt01@yahoo.co.uk> wrote in message
news:eDC3GwACGHA.312@TK2MSFTNGP09.phx.gbl...
> 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.
>

Belated thanks Sandy (Virus problems with Trojan Adclickers prevented an
earlier reply.)
Happy New Year,
Graham B

"Sandy Mann" <sandymann2@mailinator.com> wrote in message
news:enS5N$ACGHA.3812@TK2MSFTNGP15.phx.gbl...
> 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
> sandymann2@mailinator.com
> Replace@mailinator.com with @tiscali.co.uk
>
>
> "Graham B." <bertiegt01@yahoo.co.uk> wrote in message
> news:eDC3GwACGHA.312@TK2MSFTNGP09.phx.gbl...
>> 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.
>>
>
>

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" <sandymann2@mailinator.com> wrote in message
> news:enS5N$ACGHA.3812@TK2MSFTNGP15.phx.gbl...
>
>>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
>>sandymann2@mailinator.com
>>Replace@mailinator.com with @tiscali.co.uk
>>
>>
>>"Graham B." <bertiegt01@yahoo.co.uk> wrote in message
>>news:eDC3GwACGHA.312@TK2MSFTNGP09.phx.gbl...
>>
>>>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

You're welcome Graham, glad that you got the dinner, trojan & your
spreadsheet all sorted out.

--
Regards

Sandy
sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

"Graham B." <bertiegt01@yahoo.co.uk> wrote in message
news:%23jEBatgDGHA.3772@TK2MSFTNGP09.phx.gbl...
> Belated thanks Sandy (Virus problems with Trojan Adclickers prevented an
> earlier reply.)
> Happy New Year,
> Graham B
>
> "Sandy Mann" <sandymann2@mailinator.com> wrote in message
> news:enS5N$ACGHA.3812@TK2MSFTNGP15.phx.gbl...
>> 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
>> sandymann2@mailinator.com
>> Replace@mailinator.com with @tiscali.co.uk
>>
>>
>> "Graham B." <bertiegt01@yahoo.co.uk> wrote in message
>> news:eDC3GwACGHA.312@TK2MSFTNGP09.phx.gbl...
>>> 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.
>>>
>>
>>
>
>