Hi Khad,

Even with a night's sleep I am still having difficulty understanding what it
is that you are trying to do. I guess from:

realised when i moved time brackets eg 22:00-05:59 the duty time

that you are having problems when the times cross midnight and you want to
calculate the number of hours from 22:00 to 5:59 the next morning.. If so
then with 22:00 in A1 and 05:59 in B1, try using:

=MOD(B1-A1,1)

This will give you the correct answer whether or not the time does cross
midnight so it can be used for all calculations.

If I am wrong then post back giving as much datail as possible including the
fomulas that you are using and the layout of your data.


--
HTH

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


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


"Sandy Mann" wrote in message
...
Khad,

It has gone Midnight where I live and so I am off to bed just now. If no
one else responds I will have a look at it tomorrow.

--
Regards,

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 sandy

sectors are the flights e.g london-new york =1 sector new york - lon =2
so what i am trying to do is calculate what duty hours i can do if called
out from standby, which a duty we carry out at home waiting to be called
or
not. but during the time blocks shown there are 2 veriables the sectors
that
you could be asked to fly, then the duty limitation placed on you during
the
time brackets, i need to get the allowed fdp cell to recognise all the
differant duty limits relating to the sectors, eg 06:00-07:59 4 sectors =
10:45 10 hrs 45 mins of duty, now the formula that i had wrote took care
of
the 06:00-07:59 times, but after you solved the other problem i had i
soon
realised when i moved time brackets eg 22:00-05:59 the duty time did not
match the time for the amount of sectors eg 4 sectors in that time
bracket =
09:00 9 hrs duty, because i have written the formula wrong.

i think this is a tough nut to crack, a long formula, way beyond my
simple
knowledge of excel.

anyway thanks for your help so far