| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
get average per hour?
I have got a couple of fiqures, the total time spent doing somthing, format (h):mm And the number of things done but when i try to calculate the number of things done per hour, it dosent work. the caluculation should work out to be 51 (things) 20:31:44 (hours) - (shown on excel as 20:31 due to my formating) should equal 2.49 per hour but the calculation comes to 59.62?????? Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average dynamic data cells over a one hour period? | Excel Discussion (Misc queries) | |||
| Average based on Hour | Excel Worksheet Functions | |||
| plotted Average | Charts and Charting in Excel | |||
| What is this kind of average called? | Excel Worksheet Functions | |||
| average function in Excel 2002 | New Users to Excel | |||
Threaded Mode
