Are your times in different columns, or do you have date/times in column A and B?

If you were going from, say, 16:00 on one day to 12:00 on the next day, would this count as 1 day? And if the start date were the last day of the month and the end date was the first of the next month, how would you like that to be apportioned?

Please post another example workbook with date/times, showing how you would like those to be apportioned.

Pete