Lets assume A1 = start time and B1=end time

If the start time is 1430 hours and the end time is 2300, how do I get results of 7.5 hours. I have tried the mround formula with .25 but it calculates 7.5 hours as 7.75 hours because it's subtracting 30 from 100 and then rounds to the nearest quarter.

I also need the formula to calculate hours that over lap into the next morning. So if the start time is 2215 and the end time is 0600, then the correct answer should be 7.75.

All of this is trying to be calculated in the same cell.

Any help would be appreciated.

Thanks.