| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours)
Guys i need help with a function in Excel.
I need to substract the time difference to identify the time taken to complete a task, however the following needs to be included - List of Holidays - During Business Hours Only Hence if A1 = Activity Start Date B2 = Activity End Date X1 = Business Hours Start Time X2 = Business Hours End Time R1:13 = List of Holidays How would i get this done ? I dont want to use the work days formula as it excludes Weekends. Please help ! |
|
#2
|
|||
|
|||
|
Quote:
Any luck guys ? Is this possible or aint ? |
|
#3
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating diff between date/ time only between certain hours | Excel Discussion (Misc queries) | |||
| Calculating diff between date/ time only between certain hours | Excel Discussion (Misc queries) | |||
| using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours | Excel Worksheet Functions | |||
| daily activity time log | Excel Discussion (Misc queries) | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Linear Mode
