| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date and Time Response- before/during/after Business hours | Excel Discussion (Misc queries) | |||
| How do I add time abouve 10000 hours in excel? | Excel Worksheet Functions | |||
| Excel Time Sheet - Rounding To Quarter Hours | Excel Worksheet Functions | |||
| How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) | |||
| in excel totaling weekly hours military time | Excel Worksheet Functions | |||
Linear Mode
