hi, Dennis !

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.

[E5] =min(d5,8/24)
[F5] = d5-e5

hth,
hector.

p.s. you could review your previous post (yesterday) :)