How do I add together time and hours in Excel?

J

JimG

I'm new at using Excel 2002. I want to make a spreadsheet for cooking times.
I want to start cooking a roast at 8:30 am. I want to cook it for 2 hours. I
then want to let it rest for 30 mins. How would I add these times together to
get 11:00 AM?
Thanks for your help.
 
D

Dave Peterson

put 8:30 in one cell (a1)
put 2:00 in another (a2)
put 0:30 in another (a3)
put =sum(a1:a3)
and format it as time.
 
Top