Assuming that your times are really XL times and the Standby Start time is
in D25 with the fpd start time in D27 then try

=MIN(D27-D25,TIME(6,,))+L25


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"khad" wrote in message
...
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.