How do I add together time and hours in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate cooking time 3
Time Sum in Excel 1
How to enter start and end date/time in excel based on some specific value. 7
How do I set up a time sheet in Excel? 8
Adding time in 24 hour format to produce hours in decimal format 11
Calculate time with a break and total hours 5
time formats 5
How do I round time down to the nearest half hour? 3

Back
Top