time calculation for airline standby
 

could anyone help regarding a calculation re the above.

what i am try to do is this: i start a standby at 6:00 and i finish it at
18:00 = 12 hrs
but i am called to work at 15:00, so i have completed 8hrs stby. now i can
only count 6 hrs of this sby time towards my total duty time, so i have to
form a what if type of calculation.

start of sby 06:00 fdp allowed 12:15

start of fdp 15:00 total duty allowed 21:15:00

num of setors 2 max finish time 03:15:00

this calulation above is wrong as i can only work until 00:15 so i need to
tell the total duty allowed time cell to minus all time over 6 hrs ( the
differance between the start of sby and start of fdp cells.

thanks for any help

time calculation for airline standby
 

Speaking personally I cannot follow what it is you are saying. Can you
please re-state the problem. For example:
tell the total duty allowed time cell to minus all time over 6 hrs ( the
differance between the start of sby and start of fdp cells.
:But the start of your Standby was 06:00 and the start of your fdp (whatever
that is) was 15:00 yet you say that the difference is 6hours when the
figures gives 9 hours.

--
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
...
could anyone help regarding a calculation re the above.

what i am try to do is this: i start a standby at 6:00 and i finish it at
18:00 = 12 hrs
but i am called to work at 15:00, so i have completed 8hrs stby. now i can
only count 6 hrs of this sby time towards my total duty time, so i have to
form a what if type of calculation.

start of sby 06:00 fdp allowed 12:15

start of fdp 15:00 total duty allowed 21:15:00

num of setors 2 max finish time 03:15:00

this calulation above is wrong as i can only work until 00:15 so i need to
tell the total duty allowed time cell to minus all time over 6 hrs ( the
differance between the start of sby and start of fdp cells.

thanks for any help

time calculation for airline standby
 

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.

time calculation for airline standby
 

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.

time calculation for airline standby
 

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.

time calculation for airline standby
 

hi

you 2 are savours i have a sorted duty time spreadsheet now i really thank
for the time taken thanks again.