ExcelBanter - How do I add together time and hours in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I add together time and hours in Excel? (https://www.excelbanter.com/excel-worksheet-functions/113990-how-do-i-add-together-time-hours-excel.html)

JimG

How do I add together time and hours in Excel?

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.

Dave Peterson

How do I add together time and hours in Excel?

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.

JimG wrote:

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.

--

Dave Peterson

All times are GMT +1. The time now is 11:43 PM.