marvin
11-24-2014, 06:12 AM
The code from Søren Holten Hansen under (stackoverflow.com /questions/20428227/vba-excel-separate-range-of-date-in-cells/27102966) actually has part of my answer, but not completely.
I need to split dates along with their respective duration.
example: <br>
Begin Date | End Date |Duration
3-Nov 5-Nov 2.5
**I need it to look like this:**
3-Nov | 1
4-Nov | 1
5-Nov | 0.5
I need the half day to be shown on the last day. I am not sure how to make this split.
Appreciate the help this forum provides. This will really save my life!!!
Note - The other forum needed me to try something out myself, but with limited knowledge i am unable to do so :(
Thank you,
Marvin.
I need to split dates along with their respective duration.
example: <br>
Begin Date | End Date |Duration
3-Nov 5-Nov 2.5
**I need it to look like this:**
3-Nov | 1
4-Nov | 1
5-Nov | 0.5
I need the half day to be shown on the last day. I am not sure how to make this split.
Appreciate the help this forum provides. This will really save my life!!!
Note - The other forum needed me to try something out myself, but with limited knowledge i am unable to do so :(
Thank you,
Marvin.