Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average for times using minutes and seconds
Hi,
We need a formula to average out times in minutes and seconds (not AM/PM), example B3 has 3.51, C3 has 3.42, D3 has 3.37 and E3 has 3.57 (formats for these cells are just Number as using the Time format results in these times being converted to AM/PM). Can anyone help, as using just an Average formula results in results that are above 60 seconds. Thanks, Adrian |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average for times using minutes and seconds
They are not converted, just use hh:mm or [hh]:mm, all times default to the
type of time format the computer uses so you can bypass that by using the above which is actually 24 hour format -- Regards, Peo Sjoblom "aj81a" wrote in message ... Hi, We need a formula to average out times in minutes and seconds (not AM/PM), example B3 has 3.51, C3 has 3.42, D3 has 3.37 and E3 has 3.57 (formats for these cells are just Number as using the Time format results in these times being converted to AM/PM). Can anyone help, as using just an Average formula results in results that are above 60 seconds. Thanks, Adrian |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average for times using minutes and seconds
[hh]:mm should do the job but all data should be formated as time/date
sasa stankovic "Peo Sjoblom" wrote in message ... They are not converted, just use hh:mm or [hh]:mm, all times default to the type of time format the computer uses so you can bypass that by using the above which is actually 24 hour format -- Regards, Peo Sjoblom "aj81a" wrote in message ... Hi, We need a formula to average out times in minutes and seconds (not AM/PM), example B3 has 3.51, C3 has 3.42, D3 has 3.37 and E3 has 3.57 (formats for these cells are just Number as using the Time format results in these times being converted to AM/PM). Can anyone help, as using just an Average formula results in results that are above 60 seconds. Thanks, Adrian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate average given minutes and seconds | Excel Discussion (Misc queries) | |||
how do I calculate times in seconds and minutes using percentages | Excel Worksheet Functions | |||
Average time for a race in minutes seconds & tenths | Excel Worksheet Functions | |||
Formatting minutes and seconds to calculate a total average | Excel Worksheet Functions | |||
How do I enter minutes and seconds (lap times)? | Excel Discussion (Misc queries) |