What I'm trying to do is take a cell with the time at 13:30 and then what I
need to do in the next cell to the right is show no more then 8 hours, then
the next cell to the right of that must show the overage which would be 5.5
hours. If there is any help please let me know . Here is what I'm trying to
do for an example.

D5 is 13:30, E5 would be 8 then F5 would be 5.5 If time was less then 8
hour it would be D5 7, E5 would be 7 and F5 would be 0.