Posted to microsoft.public.excel.misc

JB Bates[_2_] JB Bates[_2_] is offline

external usenet poster

Posts: 36

Duty Time Calculation

I want to calculate duty time, but where the crew may not be on and
off duty the same leg - can you advise how i would do that?

Duty On Duty Off
Leg 1 13:00
Leg 2
Leg 3 23:30

how can I have it look at the duty off column and keep looking till it finds
a time? and getting the result as 10.5 Hours

thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I calculate duty times	Sala	New Users to Excel	1	December 23rd 08 01:18 PM
Rotating duty roster	gramps	Excel Discussion (Misc queries)	8	August 1st 07 12:04 PM
Stamp Duty	Mr Stanley (UK)	Excel Worksheet Functions	4	July 19th 06 11:49 AM
Please help with enclosed schedule of duty	Huawei	Excel Worksheet Functions	10	January 13th 06 02:46 PM
OT- Need to create an 11 & 12 man Duty Roster	Gunjani	Excel Worksheet Functions	0	May 20th 05 05:24 PM

All times are GMT +1. The time now is 11:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us