| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate number days + hours to complete a project
I need to calculate the number of days + hours it takes to complete specific
projects. Column A Column B Column C Column D Column E Column F Date Start Time Start Date End Time End No. Days No. Hours The Date calculation I can get. It is the time start and end that I cannot work out. As something may get started but end 3 days later. So I can get the days but not the hours. i.e. something may get started at 2:00 pm on one day and end at 9:00 am 3 days later. How do I calculate the hours to be 19 hours. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Cells to calculate hours and minutes taken to complete task | Excel Worksheet Functions | |||
| How to project the due date according to a number of working hours | Excel Discussion (Misc queries) | |||
| How to project the due date according to a number of working hours | Excel Worksheet Functions | |||
| How do I calculate the week day hours between 2 days | Excel Discussion (Misc queries) | |||
| How do I calculate the hours spent on a project by entering a sta. | Excel Worksheet Functions | |||
Threaded Mode
