Hi All,
I need help with finding the hours lapsed with a formula or VBA. I have 100+ rows in excel where two columns have dates with time and I need the difference in business hours. It needs to exclude Weekends and US holidays while calculating the business hours it would be great (optional). Below is the example.
A B C
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Thank you in advance,
Regards,
Shushil
I need help with finding the hours lapsed with a formula or VBA. I have 100+ rows in excel where two columns have dates with time and I need the difference in business hours. It needs to exclude Weekends and US holidays while calculating the business hours it would be great (optional). Below is the example.
A B C
Date 1 | Date 2 | Business Hours Lapsed |
3/30/2018 14:03 | 3/31/2018 19:29 | Need the result in this column |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Thank you in advance,
Regards,
Shushil