Flt and Duty times Spreadsheet

[flying_phonebox]

G'day all!

Wondering if anyone has a Flight and Duty Times spreadsheet they would be willing to pass on. Not after a commercial product just an excel macro to make life easier!

cheers

[goldeneagle]

I knocked one up about 2 years ago while instructing and waiting for the phone to ring. By memory, format column A for date and fill down. Column B and C are start and stop duty times 24hr format, and column D should sum these. Construct a C1 + C2 etc formula increasing by one for column D for 14 Day totals; you'll need to copy this once you've written it and then paste for a while. Column E is flight time for the given day. Columns F, G and H are 7, 14 and 365 day totals. You'll need a formula like SUM E2:E9, and then fill down and Excel will roll these over for you with the fill feature.
Be warned: as I did it, you need to start date wise when you commenced your employment.
Have Fun

[OpsNormal]

Phonebox, if your profile email addy was accepting emails from this BB you'd have one by now. Wanna PM me your email addy if you want what you seek?

Regards.
Ops:}

[dogcharlietree]

Try this;
http://www.bigfoot.com/~P-air
I've used it for a couple of years now and find it very good :ok:

[flying_phonebox]

Thanx everyone:D :D

[wandrinabout]

Ops normal

check your PM's. cheers

[wandrinabout]

Thanks Ops N, appreciated