| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Per hour calculation using whole number and hh:mm:ss
How can I calculate total per hour using data in a number cell and one in a
custome cell hh:mm:ss? For example: A1 54 emails completed A2 00:11:22 Avg per email A3 10.23 Emails per hour Normally I would have to use the following equation: 11*60=660+22=682secs*54=36828sec/60=613.8min/60=10.23per hour How can I get excel to read cell A1 and A2 and calculate A3? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Per hour calculation using whole number and hh:mm:ss
Put this in A3
=A1*A2*24 and format as number with required number of decimals... "Whitney" wrote: How can I calculate total per hour using data in a number cell and one in a custome cell hh:mm:ss? For example: A1 54 emails completed A2 00:11:22 Avg per email A3 10.23 Emails per hour Normally I would have to use the following equation: 11*60=660+22=682secs*54=36828sec/60=613.8min/60=10.23per hour How can I get excel to read cell A1 and A2 and calculate A3? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 24 hour time format help with 00:00 calculation | Excel Discussion (Misc queries) | |||
| number of tasks within an hour | Excel Discussion (Misc queries) | |||
| free hour calculation worksheet | New Users to Excel | |||
| calculation of pounds per hour | New Users to Excel | |||
| How do I calculation time in excel in 24 hour method | Excel Discussion (Misc queries) | |||
Linear Mode
