Calculate cooking time

[Pierre]

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

 

[Frank Kabel]

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

 

[Bob Phillips]

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]

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)

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

Peter