Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average time for a race in minutes seconds & tenths
In Excel 2003: How do I create a formula to determine the average time in
minutes, seconds and tenths. Such as 2 min 1 sec 2 tenths plus 1 min 59 sec 6 tenths would equal 2 min 0 sec 4 tenths. Or, 2:1.2 + 1:59.6 = 2:0.4 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average time for a race in minutes seconds & tenths
Enter is as
0:02:01.2 0:01:59.6 then sum or add =A1+A2 custom format h:mm:ss.0 =AVERAGE(A1:A20) same thing there -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Gammalite" wrote in message ... In Excel 2003: How do I create a formula to determine the average time in minutes, seconds and tenths. Such as 2 min 1 sec 2 tenths plus 1 min 59 sec 6 tenths would equal 2 min 0 sec 4 tenths. Or, 2:1.2 + 1:59.6 = 2:0.4 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
elapsed time average calculcations | Excel Discussion (Misc queries) | |||
Adding minutes to time | Excel Discussion (Misc queries) | |||
The shortcut to enter time in excel should include seconds. | Excel Discussion (Misc queries) | |||
convert seconds to minutes and seconds | Excel Worksheet Functions |