Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
percentage | Excel Discussion (Misc queries) | |||
percentage | Excel Worksheet Functions | |||
Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
Percentage doesn't add up | Excel Discussion (Misc queries) |