| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding volume per hour
Need to find average volume per hour to display in a graph. Input information
is time supplied amount supplied and total supplied ie Truck # - Time Loaded - Amount Loaded - Total Amount 1 - 6:00 - 6 - 6 2 - 6:03 - 6 - 12 3 - 6:05 - 10 - 22 etc etc. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding volume per hour
=SUMPRODUCT(--(HOUR(A2:A200)=6),B2:B200)
perhaps? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Josh - Westfield Australia" <doinitsideways@hotmaildotcom wrote in message ... Need to find average volume per hour to display in a graph. Input information is time supplied amount supplied and total supplied ie Truck # - Time Loaded - Amount Loaded - Total Amount 1 - 6:00 - 6 - 6 2 - 6:03 - 6 - 12 3 - 6:05 - 10 - 22 etc etc. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count by date and hour | Excel Worksheet Functions | |||
| Calculating volume and number. | Excel Worksheet Functions | |||
| convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
| Round Time with Conditions | Charts and Charting in Excel | |||
Linear Mode
