I have a small problem that I can't seem to solve if anyone can help
it would be appreciated.

Time cells are h:mm AM/PM decimal cells are 0.00

B14 = AM time(eg: 7:15 AM) C14 = AM time later than B14 (eg: 9:15 AM)

D14 = PM time (eg: 2:30 PM) E14 = PM time later than D14 (eg: 7:15 PM)

I need to make B15 tell me that if B14 is earlier than 8am the
difference between 8am and the time entered and give me the answer in
a decimal number. In this case the answer is 0.75

I then need to make B16 tell me the difference between 8am and the
time in C14 in a decimal number. In this case the answer is 1.25.

I also need D15 tell me that if E14 is after 6pm the number of hours
from 6pm to the time entered in decimal number. In this case the
answer is 1.25

And likewise I need cell D16 to give me the time difference between
cell D14 and E14 up to 6pm. So in this case the answer is 3.5.

If there is any excel guru out there that can figure that out please
feel free to solve away.