| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total Items Per Hour
Good afternoon,
I am having a problem when it comes to getting a total of items per hour here is an example: A B C D E F FL Fld Fl Itms Fld Itms Fl Per Hr Fld Per Hr 39,496 390,556 29:33:34 292:17:59 1,336.16 1336.149063 in columns E & F are where I am using the formula in column E: =A3/C3/24 and I'm getting the total 1,336 and it should be between around 300-500 items in column F: =B3/D3/24 and I'm getting the total 1336 and this actually is about right. my concern is I'm getting the same total for both fields. I appreciate your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a total field for a pivot table/pivotchart | Excel Discussion (Misc queries) | |||
| running total.....hepl!!! | Excel Discussion (Misc queries) | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| sum of total hours not correct | Setting up and Configuration of Excel | |||
| show in a excel graphic a total percentage for 5 diff data fiels | Charts and Charting in Excel | |||
Threaded Mode
