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 |
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 |
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 |
All times are GMT +1. The time now is 12:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com