Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Guys i need help with a similar 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 ! Quote:
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
Workday With Weekends Excluding Holidays | Excel Worksheet Functions | |||
Formula - Excluding weekends & holidays | Excel Worksheet Functions |