Percentage
I have to collate monthly hours flown by two units.
I need a break down in percent of each unit useage for the first 30 hours and then again for the remaining hours above 30. Is it possible? -- AOU |
Percentage
Tell us how the data is set out.
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "AOU" wrote in message ... I have to collate monthly hours flown by two units. I need a break down in percent of each unit useage for the first 30 hours and then again for the remaining hours above 30. Is it possible? -- AOU |
Percentage
Columns:
A B Unit Hours Police 0:20 Police 0:30 Medical 0:10 Police 0:50 Medical 0:05 medical 0:55 and so on...... Cells: Total hours for the month C2 D2 Police Medical C8 D8 Police Medical Percentage Percentage of hours of hours used used under 30 hours under 30hours. Cells: C10 D10 Percentage Percentage use over use over 30hours 30hours Hope that helps. -- AOU "Bernard Liengme" wrote: Tell us how the data is set out. -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "AOU" wrote in message ... I have to collate monthly hours flown by two units. I need a break down in percent of each unit useage for the first 30 hours and then again for the remaining hours above 30. Is it possible? -- AOU |
All times are GMT +1. The time now is 06:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com