Deduct Partial Vacation Hours Taken from a Date or Date Range

Look at the attached file.
you don't have to add new columns. The formula look at your column C and D dates and calculate the days or hours of vacation taken.
The only difference between the 2 (days or hours) is that you enter a date with a time as a start and end date for a person taking partial day vacation.