Calculate cooking time

This one's got me:

Trying to calculate "begin cooking" time based on length of a foods
cooking time until done, and desired done time.

IOW. . .

Need a chicken done at a certain time, lets say 5:00 PM
It takes chicken 3-1/2 hours to cook.

Am lookin for formula and formatting to calculate and return 1:30 PM
in the "begin cooking" column (based on 3-1/5 hour cooking time)

(Will eventually include additional food items each with different
cooking time length, and desired done time..) Looking for desired
"begin cooking " time.

Thanks for any suggestions.


Peter

Hi Pierre
try the following:
A1: stores your 'done - time'
A2: stores your cooking time
both entered as time and formated as time
In A3 put the following:
=A1-A2

Note: Will not work if your cooking has to start the day before
Frank


Pierre wrote:
This one's got me:

Trying to calculate "begin cooking" time based on length of a foods
cooking time until done, and desired done time.

IOW. . .

Need a chicken done at a certain time, lets say 5:00 PM
It takes chicken 3-1/2 hours to cook.

Am lookin for formula and formatting to calculate and return 1:30 PM
in the "begin cooking" column (based on 3-1/5 hour cooking time)

(Will eventually include additional food items each with different
cooking time length, and desired done time..) Looking for desired
"begin cooking " time.

Thanks for any suggestions.


Peter

Peter,

Assuming the end time is A1 as time, the cooking time in B1 as number of
hours, in C1

=A1-(B1/24)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Pierre" wrote in message
om...
This one's got me:

Trying to calculate "begin cooking" time based on length of a foods
cooking time until done, and desired done time.

IOW. . .

Need a chicken done at a certain time, lets say 5:00 PM
It takes chicken 3-1/2 hours to cook.

Am lookin for formula and formatting to calculate and return 1:30 PM
in the "begin cooking" column (based on 3-1/5 hour cooking time)

(Will eventually include additional food items each with different
cooking time length, and desired done time..) Looking for desired
"begin cooking " time.

Thanks for any suggestions.


Peter

"Bob Phillips" wrote in message ...
Peter,

Assuming the end time is A1 as time, the cooking time in B1 as number of
hours, in C1

=A1-(B1/24)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Pierre" wrote in message
om...
This one's got me:

Trying to calculate "begin cooking" time based on length of a foods
cooking time until done, and desired done time.

IOW. . .

Need a chicken done at a certain time, lets say 5:00 PM
It takes chicken 3-1/2 hours to cook.

Am lookin for formula and formatting to calculate and return 1:30 PM
in the "begin cooking" column (based on 3-1/5 hour cooking time)

(Will eventually include additional food items each with different
cooking time length, and desired done time..) Looking for desired
"begin cooking " time.

Thanks for any suggestions.


Peter

Bob, it helps and it works! Thank you. Happy eating.

Peter