Calculate cooking time

  • Thread starter Thread starter Pierre
  • Start date Start date
P

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
 
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
 
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 Phillips said:
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)
Click to expand...

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

Peter
 
Back
Top