Sounds like you don't want D27-D25 to exceed 6 hours. As 6 hours is ¼ of a
day try

=MIN(D27-D25,1/4)+L25

"khad" wrote:

hi

in reply, the above example, as you say is 9 hours differance and this is
where my problem starts, what i need to do is now tell the cell total duty
allowed, to not count any excess over 6 hours. this is an aviation thing for
working out duty times whilest on standby, in other words i can only count
the first 6 hours of the standby, no matter how long i have been on standby
before being called out to work.

so the total duty allowed cell already has a calculation =D27-D25+L25. this
basically is start of fdp cell minus the star of sby cell plus the fdp
allowed cell. now i need to tell the total duty allowed cell to also ignore
all time over 6 hours between the start of fdp and start of sby cells, a
seperate equation i guess but i cant figure this 1 out.

thanks again for any help.