time calculation for airline standby

[khad]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[khad]

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.

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[daddylonglegs]

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]

hi

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